Posted to microsoft.public.excel.misc
|
|
In Excel, how do I only add numbers in a row that are over 0?
I just read this. How about adding the negative numbers?
"Ruthki" wrote:
try
=SUMIF(B3:I3,"0",B3:I3)
where b3:I3 are the range you are testing and summing.
R
--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391529
|