Count instances of negative number

[sharky12345]

Can someone show me a formula please that can count the number of instances that a cell value is a minus number and by that I mean less than zero?

The range will be G2:G50.

 

[RoryA]

Like this?

=countif(G2:G50,"<0")

 

[sharky12345]

Hi Rory,

No - that doesn't work for some reason. I have 1 cell currently which has a formula result of -1, so your suggestion should pick that up but it doesn't.

 

[philwojo]

What are you getting for your results and where did you put that formula, in one cell or in multiple cells?

 

[sharky12345]

This is what I'm using for the results, (in each cell within the range);

=E2-F2

And I've put Rory's suggestion in a single cell on the same worksheet.

 

[philwojo]

No I meant what did his formula give you for a result, and what are you expecting?

I tried his formula and it works just fine for me.

Can you do an =isnumber(gXX) on the cell in question, are you sure it maybe isn't formatted as text for some reason.

 

[sharky12345]

=isnumber(gXX) = TRUE and no, not formatted as text

 

[RoryA]

You still didn't say what the result of the COUNTIF formula was?