| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the how many different values in a range | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
| formula to copy last positive number in range of cells | Excel Worksheet Functions | |||
| How can I get Positive values only from the random number generat. | Excel Discussion (Misc queries) | |||
Linear Mode
