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
Hi,
Thank you for answer!
I figured there ought to be a way, although the formula don't seem to work for me. I still get a 0 in output. I'm using 365..
Regards
Thank you for answer!
I figured there ought to be a way, although the formula don't seem to work for me. I still get a 0 in output. I'm using 365..
Regards
Strange. Please check in attached file.
- Yes, but the question regarded sumproducts. 🙂