CountIFS

JiMel

I can't figure out what is wrong with the formula below, looking for some assistance.

Nick Korna

Can you provide some screenshots of the relevant columns or error (if any)?

Without that, my best guess is that your Range 1 is a date column and your Month@row is not. If this is the case, you would need to to alter the Month column (or add a helper column with a month number if text) to make it more along the lines of:

=COUNTIFS({Internal Audit Schedule Range 1},IFERROR(MONTH(@cell),0)=Month@row,{Internal Audit Schedule Range 2},"Complete On Time")

Hope this helps, but if any problems/questions, let us know!

JiMel

Nick, below is the error I'm getting.