| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum up two result in one column
How can I sum up numbers which are 0 and <0 respectively in one column?
e.g. in Column A, I have 12 -46 90 32 -56 -34 how can I set the fomula that only minus number are sumed up? thanks. -- Lowan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum up two result in one column
Assuming your numbers are in A1 to A6
=SUMIF(A1:A6,"<0",A1:A6) =SUMIF(A1:A6,"0",A1:A6) "Lowan Chan" wrote: How can I sum up numbers which are 0 and <0 respectively in one column? e.g. in Column A, I have 12 -46 90 32 -56 -34 how can I set the fomula that only minus number are sumed up? thanks. -- Lowan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum up two result in one column
=SUMIF(A1:A6,"<0",A1:A6) for negative,
=SUMIF(A1:A6,"0",A1:A6) for positive numbers. Regards, Stefi €˛Lowan Chan€¯ ezt Ć*rta: How can I sum up numbers which are 0 and <0 respectively in one column? e.g. in Column A, I have 12 -46 90 32 -56 -34 how can I set the fomula that only minus number are sumed up? thanks. -- Lowan |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum up two result in one column
Stefi;402893 Wrote: =SUMIF(A1:A6,"<0",A1:A6) for negative, =SUMIF(A1:A6,"0",A1:A6) for positive numbers. Regards, Stefi €˛Lowan Chan€¯ ezt Ć*rta: How can I sum up numbers which are 0 and <0 respectively in one column? e.g. in Column A, I have 12 -46 90 32 -56 -34 how can I set the fomula that only minus number are sumed up? thanks. -- Lowan Hi if you only have one range, the third argument is optional =SUMIF(A1:A6,"<0") will also work -- Pecoflyer Cheers - 'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html) really IS fast ! ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112377 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| result column | Setting up and Configuration of Excel | |||
| finding the largest value for a name in a column and then returningthe result from a different column | Excel Worksheet Functions | |||
| If column = value sum another column and place result in cell | Excel Discussion (Misc queries) | |||
| add numbers in a column and transfer result to another column | Excel Worksheet Functions | |||
| Trying to sum column but getting 0 as result | Excel Discussion (Misc queries) | |||
Linear Mode
