2D SUMIFS Problem

Hi guys, hopfully someone can help!

I have made a simple version of my problem below:

 

a              5          5         5        10       10       10

b              4          3         4        10       12       12  

c              6          7         4         9         8        13

d              5          6        12        10      11        7

e              3          2          1         5        6         5 

 

              yes        yes       yes       no      no      no

 

I need to be able to add up all of the figures that have common properties e.g are “a” and “yes” would =15, “e” and “no” would =16

Im struggling with this as SUMIFS only works on a 1D array

This raw data then pulls through to another summary sheet which basically looks like this, and the totals will be filled in:

 

       Yes     No

a      15

b

c

d

e               16

 

So I need a standard formula for the table

 

Hopefully I’ve explained this well enough!

By: squareguy4

Leave a Reply

Your email address will not be published. Required fields are marked *