View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
 
Posts: 209
Default Count number of positive values in range

Ooops!!!
You're right! :O
CountIf( )
--
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


"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