Count IF formula


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
    Nic Larsen ✭✭✭✭✭✭
    edited 10/20/23

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!