Sum row values with column header

[sdsurzh]

Hi,


I have data in column A with header called Income below that lot of numbers there. i want to add those numbers. i tried sumif and sumifs also but no use. please help me


Thanks,

Suresh Kumar S

 

[jason]

you want to add all of the numbers in the column?


=sum(A2:A100)


obviously, you'd want to change the cell references to match your sheet.

 

[Debraj]

Hi Suresh,


# of post 381.. I guess its not a easy question.. but think differently.. when SUMPRODUCT can add RowWise.. It can Sum Column wise also.. If data is in below Format..

[pre]

One	Income 	Three
10	33	53
67	52	41
11	11	95
53	46	29
70	2	56
67	19	57
7	13	29
13	46	39
17	8	35
33	92	63
88	82	54
100	99	1
94	84	22
65	20	19
57	88	54
5	24	88
4	6	77
84	83	39
57	4	85
83	92	56
28	10	90
87	73	50
9	6	77
47	50	99
28	36	45
96	60	94
8	22	82[/pre]
Use formula as

=SUMPRODUCT(($A$1:$C$1="Income")*A2:C40)

Hope I decoded your expected question..


Regards,

Deb

 

[sgmpatnaik]

@Suresh


Hi


May be Deb is correct please give some more details as per your requirement


you can use the deb formula and mine also try this


=SUM(A:A,$A$1)


Thanks


SP

 

[sdsurzh]

Thanks Jason, Deb & SP.