or Explore Discussions

#### 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.

# formula help

✭✭✭✭✭
edited 12/09/19
06/30/17 Edited 12/09/19

I am attempting to get a formula to count a range if the column next to it has the correct category. for example

DF  1.1

DV  2.1

DF  3.3

DF  1.2

DV  2.1

I want to count how many numbers lay between 1 and 2 in the category DF, and am struggling to get the program to do this.  Any help would be appreciated.

• Hey Luke,

Have you tried the CountIF function? I know I use the formula below to count how many projects are in "Red"

=COUNTIF(Status3:Status90, "Red")

• I am sorry I don't really understand what you are trying to count, or I would come up with a formula to help. But my example should be a good template for you.

• ✭✭✭✭✭

That would work if there wasn't a range.  Using a range throws logic into it that I haven't been able to get the countif function to accept so far. Thanks though

• ✭✭✭✭✭

See if this works... replace primary column with your column name. (Remove brackets [ ] if there are no spaces in the column name]

=COUNTIF([Primary Column]:[Primary Column], OR(LEFT(@cell, 4) = "DF 1", LEFT(@cell, 4) = "DF 2"))

https://help.smartsheet.com/articles/2476491/create-efficient-formulas-with-at-cell

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

• ✭✭✭✭✭

Thanks. I always seem to have problems with the countif function. I appreciate the help!

• ✭✭✭✭✭

You are welcome. Formulas are tricky, but over time they will grow on you. The nuances of Smartsheet will do the same.

This discussion has been closed.