| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting Cells being used in Calculation
A are the row numbers
B Revenue streams C Revenue Amounts A B C Total 265 P Sales 40,039,874.16 266 Adj (3,314,674.99) 267 SW Sales 7,328,930.75 268 SW Adj 4,443,225.97 269 TP Sales 13,626,743.20 270 TP ADJ (1,047,169.60) 271 Others (12,139,812.20) 272 Others Adj (33,517.04) 273 Suspense 1,686,250.49 274 TOTAL 50,589,850.74 275 Service 363,695.33 276 Service Adj 480,921.08 277 Consultancy 2,076,780.35 278 Consultancy Adj (2,026,051.39) 278 * Net Service Sales 1,044,701.68 278 ** Total Net Sales 51,634,552.42 Sum Formula =C265+C267+C269+C275+C277 How can i highlight cells/rows being used in the sum formula above with individually selecting them??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add cells by highlighting them? | Excel Discussion (Misc queries) | |||
| Highlighting cells | Excel Worksheet Functions | |||
| highlighting cells | Excel Discussion (Misc queries) | |||
| HIGHLIGHTING CELLS | Excel Discussion (Misc queries) | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Threaded Mode
