Count number of positive values in range
 

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

Count number of positive values in range
 

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

Count number of positive values in range
 

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

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

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

Count number of positive values in range
 

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

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

Count number of positive values in range
 

You're welcome, Deirdre - thanks for feeding back.

Pete

"Diddy" wrote in message
...
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