Sum(sumifs with multiple critera

Hi,
Im trying for a result with 2 variable columns and 1 constant, so colum 1 = "a " OR "b", 2= "x" OR "y" but 3 has only one value;

SUM(SUMIFS(G5:G13,D5:D13,{"x","y"},E5:E13,{"S","M"},F5:F13,"Blue"))

the problem is that X maps onto S and Y onto M, I'm after x = S or M and "blue" and y= s or m and blue. I've tried splitting it into two and adding together, but it's very long and doen't seem to work anyway.

Help.

Dicken.

When using 2 OR criteria you need to use a semi-colon in one of them like

Formula:

Please Login or Register  to view this content.

Hi Diana,

I've attached a simplified workbook, but it illustrates what I'm tryin to do. I've also tried using 'sumproduct'. which works for
X or Y and A and B and C. But not X or Y and A or B and C. At least that's where I'm at.


RD

Did you try what I suggested?