CountIf

[Kintantay]

In column J of my spreadsheet I have the following formula:
countif(insheet!$j$43:$j$59,">10%")+countif(insheet!$j$43:$j$59,"<-10%")
This counts items >10% and <-10%. Fine.

I tried to apply the same principles in the same column with items that are >1% but <9.But the formual seems to count the zeros. Want I want is the formula to count items >1 but <9 & <-1 but >-9 in one formula. Is that possible?

Thanks in advance

 

[Juan Pablo González]

How about something like

=COUNTIF(Rng, ">-9%") - COUNTIF(Rng, ">=9%") - COUNTIF(Rng, 0)

this assumes that you don't have any values between -1% and 1% (like 0.5% for example)

 

[Kintantay]

Does this formula excludes values that equal zero?

 

[Juan Pablo González]

Yep

 

[Kintantay]

Owe Great Juan!

If you had a ring, I would kiss it..