COUNTIFS function with two criteria

Carolina Rivera
edited 06/04/20 in Formulas and Functions

Hi all!

I'm currently trying to count how many red entries (in the "Puri Safety" column) are in the month of June (using the "Created" column). I'm trying to use the following formula:

=COUNTIFS(Created:Created, IFERROR(MONTH(@cell), 0) = 6, [Puri Safety]:[Puri Safety], "Red")

However, it returns a value of zero... what must be the problem? Please find attached a screencap of the grid to better visualize my issue. (I would also like to count the red entries per day, would the formula be similar?)


Carolina Rivera

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!