Double count in SUMPRODUCT formula

[Luis Ah Hoy Jr]

Hi.
There are two questions inherent to this thread. But let's go step-wise:


I have this formula in which I want to sum items (Description) that contains ANY of the strings in the C16 to C17 range:
= SUMPRODUCT( SUMIFS(Value; Description; "*"& C16:C17 &"*") )


This formula however, double counts any rows that contain BOTH strings.
Any idea on how to get around this?



Link to the .xlsx file:
http://www.mediafire.com/file/r91n3txj13vl21c/SUMIFS_excl_w2.xlsx

 

[James006]

If I am not mistaken ... double-post ...


See Double counting in SUMPRODUCT formula

 

[Luis Ah Hoy Jr]

The two sites (MrExcel and OzGrid) are related?
If so, my apologies.