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