Excel SUMIF or SUMIFS Formula Help

[wezar]

Hello, I have a huge spreadsheet that I am trying to do a summary on. I thought using a SUMIFS formula would work but I just can't seem to get the correct formula, I keep getting ERROR messages. Any help would be greatly appreciated. Please see structure below.

Current Spreadsheet
Company Name	Product 1	Product 2	Product 3	Product 4	Product 5	Total	Rev Month
A Company	1,000	1,000	1,000	1,000	1,000	5,000	Jul-18
B Company	-	-	1,000	1,000	-	2,000	Jul-18
C Company	1,000	-	-	1,000	-	2,000	Aug-18
D Company	-	-	-	1,000	-	1,000	Sep-18
A Company	1,000	1,000	1,000	1,000	1,000	5,000	Sep-18
A Company	1,000	1,000	1,000	1,000	1,000	5,000	Sep-18
	4,000	3,000	4,000	6,000	3,000	20,000
Spreadsheet Needed
	Jul-18	Aug-18	Sep-18
Product 1
Product 2
Product 3
Product 4
Product 5
	0	0	0

<tbody>
</tbody>

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	Company Name	Product 1	Product 2	Product 3	Product 4	Product 5	Total	Rev Month
2
3	A Company	1,000	1,000	1,000	1,000	1,000	5,000	Jul-18
4	B Company	-	-	1,000	1,000	-	2,000	Jul-18
5	C Company	1,000	-	-	1,000	-	2,000	Aug-18
6	D Company	-	-	-	1,000	-	1,000	Sep-18
7	A Company	1,000	1,000	1,000	1,000	1,000	5,000	Sep-18
8	A Company	1,000	1,000	1,000	1,000	1,000	5,000	Sep-18
9		4,000	3,000	4,000	6,000	3,000	20,000
10
11
12		Jul-18	Aug-18	Sep-18
13	Product 1	1000	1000	2000
14	Product 2	1000	0	2000
15	Product 3	2000	0	2000
16	Product 4	2000	1000	3000
17	Product 5	1000	0	2000
Sheet1

Cell Formulas
Range	Formula
B13	=SUMIFS(INDEX($B$3:$G$8,0,MATCH($A13,$B$1:$G$1,0)),$H$3:$H$8,B$12)
C13	=SUMIFS(INDEX($B$3:$G$8,0,MATCH($A13,$B$1:$G$1,0)),$H$3:$H$8,C$12)
D13	=SUMIFS(INDEX($B$3:$G$8,0,MATCH($A13,$B$1:$G$1,0)),$H$3:$H$8,D$12)

 

[wezar]

Thank You, that formula works !!!!

 

[Fluff]

Glad to help & thanks for the feedback