Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
