How to find the sum of particular cells

[GirishDhruva]

Hi Everyone,
I have a table [TABLE="width: 500"]
<tbody>[TR]
[TD]Basic[/TD]
[TD]HRA[/TD]
[TD]PF[/TD]
[TD]PT[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]324[/TD]
[TD]345[/TD]
[TD]5654[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]234[/TD]
[TD]354[/TD]
[TD]6776[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]345[/TD]
[TD]657[/TD]
[TD]7897[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]234[/TD]
[TD]345[/TD]
[TD]57[/TD]
[TD]7895[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]234[/TD]
[TD]456[/TD]
[TD]5687[/TD]
[TD]786[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]678678[/TD]
[TD]345[/TD]
[TD]456[/TD]
[TD]567[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]567[/TD]
[TD]35[/TD]
[TD]6734[/TD]
[TD]674[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]564[/TD]
[TD]56734[/TD]
[TD]575[/TD]
[TD]6754[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]68[/TD]
[TD]3456[/TD]
[TD]3567[/TD]
[TD]865[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD]4356[/TD]
[TD]567[/TD]
[TD]56[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]345[/TD]
[TD]55637[/TD]
[TD]5467[/TD]
[TD]54677[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]234[/TD]
[TD]6435[/TD]
[TD]6[/TD]
[TD]435634[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]563[/TD]
[TD]465[/TD]
[TD]3456[/TD]
[TD]435634[/TD]
[TD]sum of basic+hra+pf[/TD]
[/TR]
[TR]
[TD]sum of Basic[/TD]
[TD]Sum of HRA[/TD]
[TD]Sum of PF[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I need to Find.....
1.First i need to find the columns by its names and then total
2.To find the total(basic+HRA+PF) in last column of the table
3.Find the sum individually of basic,hra,pf in bottom of that column

Note: I will not be knowing the column numbers so don't mention the column numbers and find the sum

Thank You in Prior

 

[Michael M]

I think I'm missing something

Excel 2007
	A	B	C	D	E
1	Basic	HRA	PF	PT	Total
2	123	324	345	5654	6446
3	123	234	354	6776	7487
4	123	345	657	7897	9022
5	234	345	57	7895	8531
6	234	456	5687	786	7163
7	7E+05	345	456	567	680046
8	567	35	6734	674	8010
9	564	56734	575	6754	64627
10	68	3456	3567	865	7956
11	56	4356	567	56	5035
12	345	55637	5467	54677	116126
13	234	6435	6	435634	442309
14	563	465	3456	435634	440118
15	681912	129167	27928	963869
16
Sheet2

Cell Formulas
Range	Formula
E2	=SUM(A2:D2)
E3	=SUM(A3:D3)
E4	=SUM(A4:D4)
E5	=SUM(A5:D5)
E6	=SUM(A6:D6)
E7	=SUM(A7:D7)
E8	=SUM(A8:D8)
E9	=SUM(A9:D9)
E10	=SUM(A10:D10)
E11	=SUM(A11:D11)
E12	=SUM(A12:D12)
E13	=SUM(A13:D13)
E14	=SUM(A14:D14)
A15	=SUM(A2:A14)
B15	=SUM(B2:B14)
C15	=SUM(C2:C14)
D15	=SUM(D2:D14)

 

[GirishDhruva]

Thanks Michael M for your effort , but i need that in vba coding

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1092426-find-column-name-sum-column.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).