COUNTIF referencing another sheet with one criteria and date range

juliedesselle

Hi,

I'm creating a metric sheet that will pull data from a source sheet. I'd like to count the number of times a certain category is listed within a given month.

So far, I have =COUNTIF({Grievance Category}, "Appeal") and now I need to add the criteria of Date Received = January.

Any help is appreciated!

Julie

heyjay

=COUNTIFS(
{Grievance Category}, "Appeal", 
{Date Received}, IFERROR(MONTH(@cell), 0) = 1)

Then you can swap out the = 1 to other months as needed.

heyjay

=COUNTIFS(
{Grievance Category}, "Appeal", 
{Date Received}, IFERROR(MONTH(@cell), 0) = 1)

Then you can swap out the = 1 to other months as needed.

juliedesselle

Perfect! Thank you so much. I don't pretend to understand the IFERROR function. 😁