Count number of positive values in range
Thank you Pete - works lovely
--
Deirdre
"Pete_UK" wrote:
You can do:
=COUNTIF(range,"0")
for positive values, (or you might like to make it "=0"), and:
=COUNTIF(range,"<0")
for negative values.
Hope this helps.
Pete
"Diddy" wrote in message
...
Hi David and Gary,
It was more how to identify negative and positive values in the formula.
I hope it's not something really simple and staring me in the face but
think
it may be :-)
cheers
--
Deirdre
"David Biddulph" wrote:
It sounds as if the questioner wanted COUNTIF, not SUMIF ?
--
David Biddulph
"Gary Brown" wrote in message
...
Use the SumIf( ) function.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
"Diddy" wrote:
Hi everyone,
I've got a flexi time worksheet that I've put together with lots of
help
from you guys over time and now I'm back asking for more help :-)
I would like to be able to count the number of days where the flexi
balance
has been either positive or negative. Cells are formatted [h]:mm and
add
together balance from previous day to number of hours worked that day.
Version is 2003.
Many thanks once again
--
Deirdre
|