Sum data for selected Row

[sksanjeev786]

Hi Team,

I need a total fo A and B from all row as of now I have added manually in formula in row A23 to F23 do we have any other option

Book1
	A	B	C	D	E	F
1	A	674	836	813	994	965
2	B	764	443	883	897	362
3	C	425	957	695	869	248
4		1863	2236	2391	2760	1575
5
6	A	617	410	524	875	983
7	B	227	974	177	915	417
8	C	628	647	697	958	148
9	D	767	127	707	643	284
10	SUB NET (D6: D8)	2239	2158	2105	3391	1832
11
12	A	824	229	973	432	920
13	B	928	781	337	532	736
14	C	908	343	511	947	176
15		2660	1353	1821	1911	1832
16
17	A	542	276	974	802	435
18	B	858	153	727	412	560
19	C	463	624	953	593	590
20	D	240	820	681	533	742
21		2103	1873	3335	2340	2327
22
23	NET (A and B only)	5434	4102	5408	5859	5378
Sheet1

Cell Formulas
Range	Formula
B4:F4,B15:F15	B4	=SUM(B1:B3)
B10:F10,B21:F21	B10	=SUM(B6:B9)
B23:F23	B23	=B1+B2+B6+B7+B12+B13+B17+B18

Thanks
Sanjeev

 

[Fluff]

How about

=SUM(SUMIFS(B1:B21,$A$1:$A$21,{"A","B"}))

 

[sksanjeev786]

How about

=SUM(SUMIFS(B1:B21,$A$1:$A$21,{"A","B"}))

Perfect!!!!! Fluff

Thank you.....

 

[Fluff]

You're welcome & thanks for the feedback.