Use countifs to count all projects with a quarter date and year from a date column

Mathew Palter

my current formula is =countifs({sheet reference}, ROUNDUP(MONTH(@cell)/3) = "4", {sheet reference}, Year(@cell) = "2022"

I have ensured the column from the reference is a date column, however I am given invalid data type as an error

Paul Newcome

It sounds like you may have blanks and/or non-date values in the date column. Try a couple of IFERRORS like so:

=countifs({sheet reference}, ROUNDUP(IFERROR(MONTH(@cell), 0)/3) = "4", {sheet reference}, IFERROR(Year(@cell), 0) = "2022"

Paul Newcome

It sounds like you may have blanks and/or non-date values in the date column. Try a couple of IFERRORS like so:

=countifs({sheet reference}, ROUNDUP(IFERROR(MONTH(@cell), 0)/3) = "4", {sheet reference}, IFERROR(Year(@cell), 0) = "2022"