COUNTIF Cell Value is Negative



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 Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!