How to nest functions with SUMIF function in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bobito - 20 Nov 2005 18:28 GMT

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 "

Reply to this Message

Peo Sjoblom - 20 Nov 2005 18:31 GMT

=SUMPRODUCT(--(A1:A200="Car"),--(B1:B200="Red"),C1:C200)

note that you cannot use the whole column (no A:A or B:B)

Signature

Regards,

Peo Sjoblom

(No private emails please)

>I am trying to use 2 variables with the SUMIF function. ie:-
> sumif(<range1>,<criteria1>)(<range2>,<criteria2>),<sum_range>
[quoted text clipped - 5 lines]
> 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 "

Reply to this Message