Search across and sum down

[wannabe12]

Hi there
I have a journal where I have P1, P2 and so forth to P12 going across.
For each P* I have values for the next 10 rows i.e. values going down. Please see mini table below -
P1 is for Jan, P2 for Feb and so forth
When doing this I need to put a check in that checks the total for P1 or P*.
So I need a formula that searches for P* and when it finds it going across it totals up all the values in that column
For example for P2 the formula should return - 20,000
Thanks

P1	P2	P3	P4
15000​	5000​	15000​	25000​
25000​	5000​	80000​	30000​
40000​	10000​	95000​	55000​

 

[JamesCanale]

MrExcelPlayground5.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	P1	P2	P3	P4	P5	P6	P7	P8	P9	P10	P11	P12
2	15000	5000	15000	25000	16500	5500	16500	27500	38500	49500	60500	71500
3	25000	5000	80000	30000	27500	5500	88000	170500	253000	335500	418000	500500
4	40000	10000	95000	55000	44000	11000	104500	60500	467500	621500	775500	929500
5	51667	11667	143333	66667	56833	12833	157667	73333	682000	907500	1133000	1358500
6	64167	14167	183333	81667	70583	15583	201667	89833	896500	1193500	1490500	1787500
7	76667	16667	223333	96667	84333	18333	245667	106333	1111000	1479500	1848000	2216500
8	89167	19167	263333	111667	98083	21083	289667	122833	1325500	1765500	2205500	2645500
9	101667	21667	303333	126667	111833	23833	333667	139333	1540000	2051500	2563000	3074500
10	114167	24167	343333	141667	125583	26583	377667	155833	1754500	2337500	2920500	3503500
11	126667	26667	383333	156667	139333	29333	421667	172333	1969000	2623500	3278000	3932500
12
13	Which P?
14	5	774583.3
Sheet18

Cell Formulas
Range	Formula
B14	B14	=SUM(INDEX(A2:L11,,A14))

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	P1	P2	P3	P4
2	15000	5000	15000	25000		P2	20000
3	25000	5000	80000	30000
4	40000	10000	95000	55000
5
6
Main

Cell Formulas
Range	Formula
G2	G2	=SUM(INDEX(A2:D12,0,MATCH(F2,A1:D1,0)))

 

[Sufiyan97]

Another option

Book2
	A	B	C	D	E	F	G	H
1	P1	P2	P3	P4
2	15000	5000	15000	25000		P4	110000
3	25000	5000	80000	30000
4	40000	10000	95000	55000
5
6
Sheet2

Cell Formulas
Range	Formula
G2	G2	=SUMPRODUCT((A1:D1=F2)*A2:D4)

 

[wannabe12]

Thanks all

 

[Fluff]

Glad we could help & thanks for the feedback.