SUMIFS With Multiple Criteria

[kumara_faith]

Hi,

I have the following tables:

Book3
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2	Table 1						Table 2					Table 3
3	Date	Month	Staff	Branch	Sales		Month	Staff	Branch	Sales		Month	Staff	Branch	Sales
4	1/1/2022	Jan	Alex	England	10		January	Alex	England	0		January	Alex	England	15
5	1/1/2022	Jan	Joe	North America	0
6	1/1/2022	Jan	Alex	England	5
7	1/1/2022	Jan	Mina	Singapore	10
Sheet1

Cell Formulas
Range	Formula
L4	L4	=SUMIFS(G4:G7,D4:D7,I4,E4:E7,J4,F4:F7,K4)

I have my data table in Table 1 and summary in table 2.

I am trying to summarize the sales for Alex for the month of January using a SUMIFS but it is not showing the correct result. The correct result is in Table 3. Appreciate any help. Thanks

 

[Phuoc]

Try this:

=SUMIFS(G4:G7,D4:D7,RIGHT(I4,3),E4:E7,J4,F4:F7,K4)

 

[Dave Patton]

Sumifs.xlsm
	I	J	K	L
1
2	Table 2
3	Month	Staff	Branch	Sales
4	Jan	Alex	England	15
Sheet2

Cell Formulas
Range	Formula
L4	L4	=SUMIFS(G4:G7,D4:D7,I4,E4:E7,J4,F4:F7,K4)

Column D has Jan

or =SUMIFS(G4:G7,D4:D7,LEFT(I4,3),E4:E7,J4,F4:F7,K4)

 

[kumara_faith]

Hi Dave,

Thank you and appreciate it.

 

[kumara_faith]

Hi Phuoc,

Thank you for your solution as well. It worked too.

 

[Dave Patton]

Thanks for the feedback.