Jump to content

Two click totals


Recommended Posts

Two click totals

Here's a two-click solution to summing rows and columns of data, a problem Excel users confront on a daily basis. Here's the scenario: You have some columns of numeric data, now all you need is a grand total row.

Suppose you have numeric entries in the range A2:J10, and in row 11 you want to display the columnar totals for those values. In other words, you want to put SUM functions for each column in the cells A11:J11. To accomplish that task with just two mouse clicks, click in cell A11 and drag to J11 to select those cells. Then click the Standard toolbar's AutoSum tool.

To create grand totals for the rows of data in that range, click cell K2 and drag to select K2:K10, then click the AutoSum tool. When you do, Excel will populate each selected cell with a formula that returns the sum of the cells in columns A through J in each of the rows 2 through 10.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...