SUM using names in Excel
You can use the names typed at the top of columns or side of rows in calculations | ||||
simply by typing the name into the formula. | ||||
Try this example: | ||||
Go to cell C16 and then enter the formula =SUM(jan) | ||||
The result will show. | ||||
This formula can be copied to D16 and E16, and the names change to Feb and Mar. | ||||
Jan | Feb | Mar | ||
North | 45 | 50 | 50 | |
South | 30 | 25 | 35 | |
East | 35 | 10 | 50 | |
West | 20 | 50 | 5 | |
Total | ||||
If it does not work ! | ||||
The feature may have been switched off on your computer. | ||||
You can switch it on by using Tools, Options, Calculation, Accept Labels in Formula. | ||||
0 comments:
Post a Comment