COUNTIF Cell Value is Negative

Options

Hello!

I don't yet see this question put out there, so here we go:

I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exist in that column. (This is for a sheet summary).

Currently my formula looks like this:

=COUNTIF([Delta: Projected Hours vs. Worked & Forecasted], <0)

*My column name is Delta: Projected Hours vs. Worked & Forecasted.

Help?

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @ghurvitt

    You almost had it. You just need to reference the column slightly differently:

    =COUNTIF([Delta: Projected Hours vs. Worked & Forecasted]:[Delta: Projected Hours vs. Worked & Forecasted], <0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!