How to find the sum of particular cells

[GirishDhruva]

Hi Everyone,
I have a table

Basic	HRA	PF	PT	Total
123	324	345	5654	sum of basic+hra+pf
123	234	354	6776	sum of basic+hra+pf
123	345	657	7897	sum of basic+hra+pf
234	345	57	7895	sum of basic+hra+pf
234	456	5687	786	sum of basic+hra+pf
678678	345	456	567	sum of basic+hra+pf
567	35	6734	674	sum of basic+hra+pf
564	56734	575	6754	sum of basic+hra+pf
68	3456	3567	865	sum of basic+hra+pf
56	4356	567	56	sum of basic+hra+pf
345	55637	5467	54677	sum of basic+hra+pf
234	6435	6	435634	sum of basic+hra+pf
563	465	3456	435634	sum of basic+hra+pf
sum of Basic	Sum of HRA	Sum of PF

<tbody>
</tbody>

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).