COUNTIFS to pull data from multiple columns

Justin Laps

Hi everyone,

I'm running into an issue trying to count the number of times a word appears in a 10 column range (SCPD Log Range 9) in a one month period. I have a column that assigns the month its respective numerical value and the same for the year.

I'd expect this formula to look across all 10 columns and count how many times "Parking" appears if the month column also contains "1" and the year column also contains "2023".

I'm getting the #Incorrect Argument Set error. Any help would be appreciated!

=COUNTIFS({SCPD Log Range 9}, "Parking", {SCPD Log Range 3}, "1", {SCPD Log Range 4}, "2023")

Paul Newcome

That error is because your ranges are not the same size. All ranges within the same function must be of the same size/shape. You would either need to insert helper columns to replicate the month and year columns 9 more times each, or create 10 separate COUNTIFS (one for each of the 10 columns) and add them together.