Help needed with Formula
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.
"Millie" wrote in message
...
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
|