| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add up numbers but there are negatives
Hi,
I want a formula that will just add up the total numbers and disregard the negatives, is there a true value formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to add up numbers but there are negatives
Hi,
Try this =SUMIF(A1:A6,"0",A1:A6) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Noodlenix" wrote: Hi, I want a formula that will just add up the total numbers and disregard the negatives, is there a true value formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to add up numbers but there are negatives
Try this...
=SUMIF(A1:A10,"0") -- Biff Microsoft Excel MVP "Noodlenix" wrote in message ... Hi, I want a formula that will just add up the total numbers and disregard the negatives, is there a true value formula? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to add up numbers but there are negatives
Do you want to ignore the negative values or ignore the negative sign?
If you want to just add the positive numbers: =SumIf(a1:a10,""&0) If you want to add all the numbers, but ignore the sign: =sumproduct(abs(a1:a10)) Noodlenix wrote: Hi, I want a formula that will just add up the total numbers and disregard the negatives, is there a true value formula? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Working With Positives and Negatives | Excel Worksheet Functions | |||
| SUM negatives numbers as positive | Excel Discussion (Misc queries) | |||
| Positives and Negatives | Excel Worksheet Functions | |||
| making columns automatically turn numbers into negatives | Excel Worksheet Functions | |||
| Formula to average ignoring negatives? | Excel Discussion (Misc queries) | |||
Hybrid Mode
