COUNTIF Formula

Ivan Perez

Good afternoon, I am trying to count the # of a specific category on a different sheet by YTD. Here is the formula I am trying to use. =COUNTIF({Category}, "Procedure", {Date},IFERROR(@cell),0)=YEAR(TODAY())). Not sure what I am doing wrong. Your help will be greatly appreciated. Thank you

Kelly Moore

A small tweak with a change of Function. COUNTIFS (plural) is required when you have more than one criteria. Personally, I always use the COUNTIFS (plural) function since it can always be used regardless of how many criteria is needed.

=COUNTIFS({Category}, @cell = "Procedure", {Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

cheers,

Kelly

Kelly Moore

A small tweak with a change of Function. COUNTIFS (plural) is required when you have more than one criteria. Personally, I always use the COUNTIFS (plural) function since it can always be used regardless of how many criteria is needed.

=COUNTIFS({Category}, @cell = "Procedure", {Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

cheers,

Kelly

Ivan Perez

Thank you very much for your help.