Help needed with Formula
=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
"Millie" wrote:
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
|