Excel Frequency Of Combination Of Two Columns – 2420

Salama from YouTube has two columns of numbers. The area in column A is from 1 to 36. The month in column B is from 1 to 12. How many times does each combination of Area and Month happen?
Today’s video offers three methods.
Table of Contents
00:00 Problem and solving with SUMIFS
01:27 Solving with a pivot table
02:25 Solving with three dynamic arrays