Is there a way to create a single count formula that will return the number of rows using two criteria?
I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
Try COUNTIFS()
https://help.smartsheet.com/articles/775363-using-formulas#countifs
Craig
Thank you Craig, that did the trick!
Now I have 3 variables I need to have considered. I know that it will only consider dates if there is something in the cell, but is there a way to have an equation ignore and empty date cell?
Getting #INVALID DATA TYPE for the following formula. Help!?
=COUNTIFS(Column1:Column1, "Apples", Action1:Action1, "sold", Date:Date, MONTH(@cell) = 2)
Christie,
This error is very difficult to troubleshoot without seeing the sheet.
The likely culprit is the MONTH(@cell), but I can not reproduce with the usual suspects.
Unrelated, I recommend avoiding column names with a number at the end. The system can get confused between Column1 and [Column]1
If you are referencing columns with names like this, better to be explicit in the name.
=COUNTIFS([Column1]:[Column1], "Apples", [Action1]:[Action1], "sold", Date:Date, MONTH(@cell) = 2)
Sorry I wasn't more help.
Thanks Craig! I will tinker with it.
