Help needed with Formula

  • Thread starter Thread starter Millie
  • Start date Start date
M

Millie

Can you use "AND", "IF" and "SUM" Functions together?

I want a formula that will do the following;
IF C:C = "Name" AND I:I = "5" then SUM K:K
 
Try this

=SUMPRODUCT(--(C1:C1000="Name"),(I1:I1000=5)*(K1:K1000))

You can not use whole columns (C:C) you have to define a range.
 
You can but this would be a better solution

=SUMPRODUCT((C1:C30="Name")*(I1:I30=5)*(K1:K30))

Note that this looks for numeric 5. You had five in quotes indicating a
string and if you really mean that put the 5 in the formula in quotes.

Mike
 
=SUMPRODUCT(--(C1:C100="Name"),--(I1:I100="5"),K1:100)

IF 5 is a numeric value then remove the quotes around the 5
you can not use a whole column unless you use XL-2007
 
Back
Top