Count number of positive values in range

[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

 

[Gary Brown]

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

 

[David Biddulph]

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

 

[Gary Brown]

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

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

 

[Diddy]

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

 

[Pete_UK]

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

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

 

[Diddy]

Thank you Pete - works lovely
--
Deirdre

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

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

 

[Pete_UK]

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

Pete

Thank you Pete - works lovely
--
Deirdre

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

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