#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Combining COUNTIF and COUNT(CHILDREN) formulas

Options
edited 12/09/19

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

• ✭✭✭✭✭✭
Options
• edited 03/01/17
Options

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)

• ✭✭✭✭✭✭
Options

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

• edited 03/02/17
Options

Thanks Craig!  I will tinker with it.

This discussion has been closed.