Do I use an IF function?
Hi
use SUMPRODUCT. e.g.
=SUMPRODUCT(--(A1:Z1="cond_1"),--(A2:Z2="cond_2"),A3:Z3)
--
Regards
Frank Kabel
Frankfurt, Germany
mips wrote:
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")
|