Multiple array SUMIFS (Tryed SUMIFS with INDEX and MATCH)

[platypus007]

Hi I need your help with this:

I need to sum by multiple criteria located on rows and columns. the problem is in picture attachement
I tryed SUMIFS with INDEX and MATCH - but it gives me only first occurance
I tryed SUMPRODUCT - but it works for less criteria

Can you please help, me with this?
Thanks
Viktor

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.
Also please post some sample data using the XL2BB add-in, it saves members from having to type it all out themselves.

 

[platypus007]

Im using 2016 Pro version - I didnt find where to add information to my account about what excel Im using.
I downloaded add-on and activated by after it copied range to clipboard it didnt paste any content to post...

 

[Fluff]

You need to paste the data into the reply window, the add-in just puts it in the clipboard.

To update your account details follow this link https://www.mrexcel.com/board/account/account-details
Then select your version of Excel & Platform, then scroll down & click save.

 

[platypus007]

What version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.
Also please post some sample data using the XL2BB add-in, it saves members from having to type it all out themselves.

OK I get it. I just asked for help and you killed my post. I hope this helps you feel important.

 

[Fluff]

Not quite sure why you feel that I've killed your post, or why you have made a personal attack on me.
I would like to help & simply asked you to help me, by supplying some information about your Excel version (which you have done & thanks for that), along with some sample data.
If you post some sample data then I will do what I can to help.

 

[Fluff]

You could try something like

=SUMPRODUCT((A4:A19=K2)*(B4:B19=K3)*(C1:H1=K4)*(C2:H2=K5)*(C4:H19))