Count number of positive values in range

  • Thread starter Thread starter Diddy
  • Start date Start date
D

Diddy

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
 
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
 
It sounds as if the questioner wanted COUNTIF, not SUMIF ?
--
David Biddulph

Gary Brown said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
It sounds as if the questioner wanted COUNTIF, not SUMIF ?
--
David Biddulph

Gary Brown said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
It sounds as if the questioner wanted COUNTIF, not SUMIF ?
--
David Biddulph

Gary Brown said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
It sounds as if the questioner wanted COUNTIF, not SUMIF ?
--
David Biddulph

Gary Brown said:
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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Thank you Pete - works lovely
--
Deirdre


Pete_UK said:
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 said:
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 said:
It sounds as if the questioner wanted COUNTIF, not SUMIF ?
--
David Biddulph

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


:

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
Click to expand...
Click to expand...
Click to expand...
 
You're welcome, Deirdre - thanks for feeding back.

Pete

Diddy said:
Thank you Pete - works lovely
--
Deirdre


Pete_UK said:
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 said:
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


:

It sounds as if the questioner wanted COUNTIF, not SUMIF ?
--
David Biddulph

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


:

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top