SUMIFS array based on switches

[mountainman88]

I have a SUMIFS formula as follows:

=SUMIFS(RptData!X:X,RptData!$A:$A,G8,RptData!$B:$B,G9,RptData!$C:$C,G10,RptData!$D:$D,$B17,RptData!$F:$F,$C17,RptData!$G:$G,$D17,RptData!$I:$I,G11,RptData!$K:$K,G12,RptData!$J:$J,G13)

This part:

RptData!$K:$K,G12

G12 is a drop-down list of items which are layers numbered 1 to 4.

What I'd like to achieve is that instead of just picking 1 layer from the drop down, can something like the following be linked to:

(this range is I3:J6)

And then each layer will be included in the SUMIFS if it is marked as 'include'

This formula needs to be able to be dragged across and down.

Thanks

 

[MountainFog]

Can you post an example file that shows desired output? I'm not understanding what you are trying to accomplish

 

[mountainman88]

Can you post an example file that shows desired output? I'm not understanding what you are trying to accomplish

It’s a SUMIFS formula at the moment g12=layer 1 and therefore the SUMIFS only pulls layer 1

I’m asking for a modification and likely an array formula that SUMIFS any layer that is marked as ‘include’ not just layer 1

 

[MountainFog]

Sounds like a job for =SUM(FILTER()). Without an example file, I'm afraid I won't be much help.

 

[mountainman88]

Sounds like a job for =SUM(FILTER()). Without an example file, I'm afraid I won't be much help.

Ok thanks anyway