Forum Discussion
Solved
Sumproduct with a wildcard condition
Dear community, I'm struggling with a formula where I want to use a wildcard condition to sum and multiply values if the corresponding month is mentioned. In other words, for January, I want to w...
Without a helper column:
=SUMPRODUCT(--ISNUMBER(FIND("Jan",N18:N22)),K18:K22,L18:L22)
Corrected typo
Without a helper column:
=SUMPRODUCT(--ISNUMBER(FIND("Jan",N18:N22)),K18:K22,L18:L22)
Corrected typo
HansVogelaar,
Did some error searching and it worked like a charm when I removed the comma before "Jan". Thank you!
SergeiBaklan,
Neat, that's one clean formula. I'm amazed by how simple some things are with the right knowledge and formulas. Very nice indeed!
=SUMPRODUCT(--ISNUMBER(FIND("Jan",N18:N22)),K18:K22,L18:L22)
Did some error searching and it worked like a charm when I removed the comma before "Jan". Thank you!
SergeiBaklan,
Neat, that's one clean formula. I'm amazed by how simple some things are with the right knowledge and formulas. Very nice indeed!
=SUMPRODUCT(--ISNUMBER(FIND("Jan",N18:N22)),K18:K22,L18:L22)
I have corrected my previous reply. Thanks for pointing out the mistake!