| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT formula to differentiate between Negative and Posit
Thanks so much, that worked!
"Peo Sjoblom" wrote: =SUMPRODUCT(--(E6:E56="uk"),--(G6:G56=0),G6:G56) Change =0 to <0 for negative numbers -- Regards, Peo Sjoblom "carol" wrote in message ... Hi, I have a formula as follows: =SUMPRODUCT((E6:E56="uk")*G6:G56) But i'd like to separate it into two cells, one picking up negative figures in the G column, and the other picking up the positive figures. Any ideas?? Much Appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exel"negative and positive days for creditors :formula | Excel Discussion (Misc queries) | |||
| formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
| IF positive/If negative???? | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
Hybrid Mode
