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

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)

KPH

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)

ghurvitt

Excellent. Thank you @KPH . I learned something!

KPH

Happy to help @ghurvitt