How to nest functions with SUMIF function in excel
=SUMPRODUCT(--(A1:A200="Car"),--(B1:B200="Red"),C1:C200)
note that you cannot use the whole column (no A:A or B:B)
--
Regards,
Peo Sjoblom
(No private emails please)
"Bobito" wrote in message
...
I am trying to use 2 variables with the SUMIF function. ie:-
sumif(<range1,<criteria1)(<range2,<criteria2), <sum_range
So far, I cannot find out if this is possible. Has anyone tried and
managed
to do this successfully?
I thought maybe that the AND function has to be used ... for example:-
Sumif(AND(A:A,"Car"(B:B,"Red",C:C))) - but with this example, I get the
error message:- "You've entered too few arguments etc "
|