Count number of positive values in range
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
|