SUMPRODUCT to pick up more than 1 column

[eemhuynh]

Hi Excel experts! I loved my SUMPRODUCT for most of the time but am currently getting a mental block for this one, could anyone please help me tweak my formula (or even different formula suggestion for the below)? So basically, I wanted to summarise Total Sale figures by: (1) product type, (2) sale status, and (3) month. I have a felling that SUMPRODUCT doesn't allow me to pick up more than 2 columns as the criteria?

 

[Fluff]

You need to add

*(D2:O15)

to your formula just before the last )

 

[FormR]

Hi, doing it this way would be my personal preference:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1				Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun
2		Consulting	Secured	718	395	476	731	207	405	291	657	983	175	626	358
3		Consulting	In Flight	201	959	300	997	640	583	626	962	162	830	809	934
4		Consulting	Unknown	443	222	834	748	308	213	448	461	115	493	488	234
5		Consulting	Forecast	437	577	798	194	546	643	344	261	785	756	323	236
6
7		Consulting	Secured	616	423	131	254	472	401	592	126	830	240	147	207
8		Consulting	In Flight	129	395	417	710	154	443	797	616	538	350	609	251
9		Consulting	Unknown	962	514	749	758	275	977	341	971	468	442	875	301
10		Consulting	Forecast	413	876	688	128	257	860	407	485	737	837	143	910
11
12		Product	Secured	245	692	132	501	737	354	443	212	309	598	508	930
13		Product	In Flight	802	163	939	443	986	209	950	539	643	210	765	450
14		Product	Unknown	651	993	824	398	862	326	195	497	537	602	376	674
15		Product	Forecast	389	177	762	403	230	538	355	933	215	910	234	563
16
17
18				Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun
19			Secured	1334	818	607	985	679	806	883	783	1813	415	773	565
20			In Flight	330	1354	717	1707	794	1026	1423	1578	700	1180	1418	1185
21			Unknown	1405	736	1583	1506	583	1190	789	1432	583	935	1363	535
22			Forecast	850	1453	1486	322	803	1503	751	746	1522	1593	466	1146
Sheet1

Cell Formulas
Range	Formula
D19:O22	D19	=SUMIFS(INDEX($D$2:$O$15,0,MATCH(D$18,$D$1:$O$1,0)),$B$2:$B$15,"Consulting",$C$2:$C$15,$C19)