Count IF formula

Anthony Nicholas

Hello,

I am trying to find the formula to use to count the number of rows assigned to an email are on a data sheet and will need counts specific for each month. Which I will adjust the formula for all the other columns months. Below I have how to pull for the user email but not sure how to add in the argument for the date/month.

The date column on the data sheet is a created date column.

=COUNTIF([User Email]@row, {BI Invoicing Errors Range 1}

Thank you for your help!!

Nic Larsen

Try something like this:

=COUNTIFS([User Email]@row, {BI Invoicing Errors Range 1}, {Date Column Range}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2019))

In this one it is counting the ones in Month January (1) and year 2019. Update to your needs