sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 882
- Office Version
- 365
- 2016
- Platform
- Windows
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
Thanks
Sanjeev
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