Lookup to return value from last column from matching criteria

[amolvijay]

Hi Expert.. I am working on a big table wherein I need to summarize the content.. base table looks as below

Practice	Location	Q1	Q1	Q1	Q2	Q2	Q2
SP	Offshore	1​	2​	3​	1​	2​	3​
CLD	Onsite	2​	3​	4​	2​	3​	4​
CLD	Offshore	3​	4​	5​	3​	4​	5​
CLD	Onsite	4​	5​	6​	4​	5​	6​
CLD	Offshore	5​	6​	7​	5​	6​	7​
SP	Onsite	6​	7​	8​	6​	7​	8​
ENT	Offshore	7​	8​	9​	7​	8​	9​
ENT	Onsite	8​	9​	10​	8​	9​	10​
ENT	Offshore	9​	10​	11​	9​	10​	11​
ENT	Onsite	10​	11​	12​	10​	11​	12​
SP	Offshore	11​	12​	13​	11​	12​	13​
CLD	Onsite	12​	13​	14​	12​	13​	14​

The summary table should look like, which is summary of resources from last month of the financial quarter... Please help me with formula to create below table

	Q1	Q1	Q2	Q2
	Offshore	Onsite	Offshore	Onsite
CLD	12​	24​	12​	24​
ENT	20​	22​	20​	22​
SP	16​	8​	16​	8​

 

[kevin9999]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Practice	Location	Q1	Q1	Q1	Q2	Q2	Q2	Q3	Q3	Q3	Q4	Q4	Q4
2	SP	Offshore	1	2	3	1	2	3	1	2	3	1	2	3
3	CLD	Onsite	2	3	4	2	3	4	2	3	4	2	3	4
4	CLD	Offshore	3	4	5	3	4	5	3	4	5	3	4	5
5	CLD	Onsite	4	5	6	4	5	6	4	5	6	4	5	6
6	CLD	Offshore	5	6	7	5	6	7	5	6	7	5	6	7
7	SP	Onsite	6	7	8	6	7	8	6	7	8	6	7	8
8	ENT	Offshore	7	8	9	7	8	9	7	8	9	7	8	9
9	ENT	Onsite	8	9	10	8	9	10	8	9	10	8	9	10
10	ENT	Offshore	9	10	11	9	10	11	9	10	11	9	10	11
11	ENT	Onsite	10	11	12	10	11	12	10	11	12	10	11	12
12	SP	Offshore	11	12	13	11	12	13	11	12	13	11	12	13
13	CLD	Onsite	12	13	14	12	13	14	12	13	14	12	13	14
14
15			Q1	Q1	Q2	Q2	Q3	Q3	Q4	Q4
16			Offshore	Onsite	Offshore	Onsite	Offshore	Onsite	Offshore	Onsite
17		CLD	12	24	12	24	12	24	12	24
18		ENT	20	22	20	22	20	22	20	22
19		SP	16	8	16	8	16	8	16	8
Sheet1

Cell Formulas
Range	Formula
C17:D19	C17	=SUMPRODUCT(($A$2:$A$13=$B17)*($B$2:$B$13=C$16),$E$2:$E$13)
E17:F19	E17	=SUMPRODUCT(($A$2:$A$13=$B17)*($B$2:$B$13=E$16),$H$2:$H$13)
G17:H19	G17	=SUMPRODUCT(($A$2:$A$13=$B17)*($B$2:$B$13=G$16),$K$2:$K$13)
I17:J19	I17	=SUMPRODUCT(($A$2:$A$13=$B17)*($B$2:$B$13=I$16),$N$2:$N$13)

 

[amolvijay]

@kevin9999 Thank you very much for your response. The formula you have suggested have manual selection of last column of each quarter, I am looking for a generic formula which will be used across without specific column selection