Count month from another sheet

Amanda Rodgers

Hi All,

I am using the following formula to count # of incidents logged by month.

=COUNTIF({AP Invoice issues log 2021 Range 10}, IFERROR(MONTH, 0) = 3))

But I am getting an #UNPARSABLE error.

Can someone advise what I am doing wrong?

David Fiorino

=COUNTIF({AP Invoice issues log 2021 Range 10}, 3) should give you a count of every cell in the AP Invoice log Range 10 (I am guessing Range 10 is the column name in that sheet) that is "3". You shouldn't need the error handler since it will only count cells that are "3".

Amanda Rodgers

I tried that and received a count of zero even though there are 43 lines that are in March

Genevieve P.

Hi @Amanda Rodgers

It looks like you're missing the reference in the MONTH function, like so:

MONTH([Specific Data]@row)

Since you're doing a cross-sheet formula, you can use the @cell function to specify that you're looking for the 3rd month in the previously stated range.

Try this:

=COUNTIF({AP Invoice issues log 2021 Range 10}, IFERROR(MONTH(@cell), 0) = 3)

Cheers!

Genevieve