Hi.
There are two questions inherent to this thread. But let's go step-wise:
I have this SUMIFS formula in which I want to include items (Description) that contains ANY of the words in cell C16 and C17:
= SUMIFS(Value; Description; "*"& C16 &"*"; Description; "*"& C17 &"*")
Unfortunately, only the items that contain BOTH words are being included in the sum.
Any idea on how to get around this?
Bookmarks