Multiple array SUMIFS (Tryed SUMIFS with INDEX and MATCH)

platypus007

New Member
Joined
Oct 24, 2019
Messages
19
Office Version
  1. 2016
Platform
  1. Windows
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
 

Attachments

  • 2020-11-02_17-16-12b.jpg
    2020-11-02_17-16-12b.jpg
    177.6 KB · Views: 73

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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. ;)
 
Upvote 0
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...
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
You could try something like
Excel Formula:
=SUMPRODUCT((A4:A19=K2)*(B4:B19=K3)*(C1:H1=K4)*(C2:H2=K5)*(C4:H19))
 
Upvote 0

Forum statistics

Threads
1,223,958
Messages
6,175,629
Members
452,661
Latest member
Nonhle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top