COUNTIF Cell Value is Negative

ghurvitt

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?

KPH

This is a duplicate post. There is an answer on this thread https://community.smartsheet.com/discussion/114379/countif-cell-value-is-negative#latest