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