Combining COUNTIF and COUNT(CHILDREN) formulas

Christie Stump

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

J. Craig Williams

Try COUNTIFS()

 

https://help.smartsheet.com/articles/775363-using-formulas#countifs

 

Craig

Christie Stump

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)

J. Craig Williams

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.

 

Craig

 

Christie Stump

Thanks Craig!  I will tinker with it.