Do I use an IF function?
Hi folks
Is there a way to test for multiple conditions before summing up? Something
like the function "sumif" but be able to test for more than one conditions.
For example, I have condition one on say row A1:Z1, condition two on row
A2:Z2, and the data that I want to sum up on row A3:Z3. Is there a
worksheet function in Excel that allows me to sum up the data contained
somewhere in row A3:Z3 only when the conditions of the respective column in
the first and second row are true.
Thanks.
"Frank Kabel" wrote in message
...
Hi
try
=SUMIF(A:A,"0")
and for the positive numbers
=SUMIF(A:A,"0")
|