Help needed with Formula
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
"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
|