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")