To learn the sum of a range of values, you need to enter a formula that refers to the values you want to sum. Right? Not really. Excel has a feature called Auto Calculate that will display the result of several functions without ever fooling with a formula. Lets suppose cells A1:A4 contain the values 1, 2, 3, as well as 4, respectively. If you want to see the sum of all four values, select cell A1. Then, drag the mouse over cells A2:A4.
Now, look on the right side of the status bar. Youll see a short message, Sum = 9. If youd rather see the normal value instead of the sum, right-click the message in the status bar and choose Avg from the context menu. Youll get several other functions available.
0 comments:
Post a Comment