Go to the tab that will hold the totals and click on the cell you want to first total to appear in. In addition to the totals on each tab, you can easily enter a formula that will total the numbers from all of the worksheets (months). Each month has its own tab in the workbook. ![]() ![]() There is a row for each product and a column to shows sales for every location. Let’s say you have a workbook that lists the month’s sales of each of your products. But did you know that you can specify a range that covers multiple tabs (worksheets) in your Excel workbook? You probably know that you can use the Sum function to add up a range of cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |