I hope my title makes sense as well as the description of my issue as I feel it's rather esoteric so please bear with me.
I had needed to work out the formula to calculate sales per month based on color name within a sku a few weeks ago, and with some help I was finally able to get it. The formula I am currently using for that is
=IF(ISNONTEXT($A3),0,SUMIFS('SALES DATA'!$B$2:$B$9984,'SALES DATA'!$D$2:$D$9984,"*"&$A3&"*",'SALES DATA'!$E$2:$E$9984,MONTH(B$1)))
However, since the products we sell are clothing, I need to somehow add another variable to this formula so it will not only detect color but size as well and place that in the correct slot, in the correct month. I know the issue sounds sort of convoluted, but all of the major hurdles have been cleared (i feel) and I just need to know how to further pare down my results. I will attach the workbook so you can fully understand.
Would I be able to just add another wildcard variable? if so, what would be the proper syntax? I applied the current formula to this workbook and have been toying with a few different things but nothing seems to work. Is this impossible with the workbooks layout or can this be done?
Bookmarks