Hello,
I am feeling like I did a poor job of explaining this prior. I am looking for a formula for cells B33-B56 on the Summary Sheet NEW tab based on criteria from the US Sales Summary Tab. There are five conditions that must be met:
1) From column C on the US sales Summary tab, the value cannot be "" (blank)
2,3,4)From column C on the US sales Summary tab, the value cannot be cell M30, M31, M32 on the Summary Sheet NEW tab
5) The value from column AI on the US Summary Sales tab cannot be 0.
Here is my formula. I do not get an error, but the formula is not following all of the conditions:
Any thoughts? Thanks!
=INDEX('US Sales Summary'!$A$5:$A$296,MATCH(MIN(IF((SUMPRODUCT(('US Sales Summary'!$C$5:$C$296<>"")*('US Sales Summary'!$C$5:$C$296<>'Summary Sheet NEW'!M30)*('US Sales Summary'!$C$5:$C$296<>M31)*('US Sales Summary'!$C$5:$C$296<>M32),'US Sales Summary'!$AI$5:$AI$296)),'US Sales Summary'!$AI$5:$AI$296,0)),'US Sales Summary'!$AI$5:$AI$296,0),1)
Thanks for your time.
Bookmarks