How to nest functions with SUMIF function in excel

B

Bobito

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

Peo Sjoblom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple SUMIF criteria 1
=sumif function 1
Help with determining instructor class location. 0
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
SUMIF with criteria 2
Replace ; with , in functions 1
can you nest sumif functions ? 2
SUMIF Sum a column subject to variables in two columns 4

Top