Need Formula HELP
*steps back, sheepishly*
yes that's a little more simple....
"Arvi Laanemets" wrote:
Hi
=SUMIF(A:A,"0",A:A)
=SUMIF(A:A,"<0",A:A)
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"Sandi" wrote in message
...
I have an Excel spreadsheet that has one column full of positive numbers
and
negative numbers. I need a formula that will add up all the positive
numbers
in one cell and all the negative numbers in another. I can do this by
selecting each cell one-by-one, but is there a faster way? It's a lot of
numbers to select one-by-one, that's why I am asking. THANKS :-)
--
Sandi Gardner
|