| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing a range based on value criteria
Hello. I am trying to find a way to only sum the numbers in a range of data
that are positive in one cell, and negative values in another cell. Can anyone please tell me what formula to use to analyze the values in the range of data to pick out only the cells with either a <0 or 0 value and to sum only those values? Thank you very much. This one is making my head feel like it's going to explode. Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing a range based on value criteria
=sumif(a1:a10,""&0)
=sumif(a1:a10,"<"&0) WiFiMike2006 wrote: Hello. I am trying to find a way to only sum the numbers in a range of data that are positive in one cell, and negative values in another cell. Can anyone please tell me what formula to use to analyze the values in the range of data to pick out only the cells with either a <0 or 0 value and to sum only those values? Thank you very much. This one is making my head feel like it's going to explode. Mike -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summing a range based on value criteria
Nevermind. I just discovered the SUMIF function.
"WiFiMike2006" wrote: Hello. I am trying to find a way to only sum the numbers in a range of data that are positive in one cell, and negative values in another cell. Can anyone please tell me what formula to use to analyze the values in the range of data to pick out only the cells with either a <0 or 0 value and to sum only those values? Thank you very much. This one is making my head feel like it's going to explode. Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing data based on criteria | Excel Discussion (Misc queries) | |||
| Summing based on criteria | Excel Worksheet Functions | |||
| Summing quantities based on like criteria? | Excel Discussion (Misc queries) | |||
| Summing based on 2 criteria | Excel Discussion (Misc queries) | |||
| Counting & Summing based on criteria on another column | Excel Discussion (Misc queries) | |||
Linear Mode
