| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula to count only positives in range
Hi
am using Excel 2003. I am trying to add only the numbers that are in posotives in a particular range. for example. A1 = 10, A2 = 11, A3 = 7, A4= -6, A5= 8. How do I go about adding all the cells except A4 in a formula? Your assistance is greatly appreicated. thanks Stadinx |
|
#2
|
|||
|
|||
|
One way
=SUMIF(A1:A5,"0") -- Regards, Peo Sjoblom (No private emails please) "Stadinx" wrote in message ... Hi am using Excel 2003. I am trying to add only the numbers that are in posotives in a particular range. for example. A1 = 10, A2 = 11, A3 = 7, A4= -6, A5= 8. How do I go about adding all the cells except A4 in a formula? Your assistance is greatly appreicated. thanks Stadinx |
|
#3
|
|||
|
|||
|
Hi!
=SUMIF(A1:A5,"0") Biff "Stadinx" wrote in message ... Hi am using Excel 2003. I am trying to add only the numbers that are in posotives in a particular range. for example. A1 = 10, A2 = 11, A3 = 7, A4= -6, A5= 8. How do I go about adding all the cells except A4 in a formula? Your assistance is greatly appreicated. thanks Stadinx |
|
#4
|
|||
|
|||
|
Hi, Yes that works, thanks for your help
"Biff" wrote: Hi! =SUMIF(A1:A5,"0") Biff "Stadinx" wrote in message ... Hi am using Excel 2003. I am trying to add only the numbers that are in posotives in a particular range. for example. A1 = 10, A2 = 11, A3 = 7, A4= -6, A5= 8. How do I go about adding all the cells except A4 in a formula? Your assistance is greatly appreicated. thanks Stadinx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
| Formula to Sum a definable range of workbooks | Excel Worksheet Functions | |||
| How do I create formula to count numbers in a range of cells? | Excel Worksheet Functions | |||
Linear Mode
