Forum Discussion
Summing across many tabs
As a basic Excel user, you probably have created a design that could itself use some modifications to work more efficiently. I'm going to guess (not a wild guess) that each tab represents a month, and that each column for which you want to show the totals is something like "Expenses" and "Income" or "Deposits" and "Withdrawals"
Let me ask you if you already do totals on each column on each tab? If you do, are those totals all in the same cell on each respective tab? If so, a straightforward way to get the totals is a formula like this (as shown in the attached sample sheet). For all twelve, you'd just extend that same system.
=Jan!A30+Feb!A30+Mar!A30
There are easier ways to do this, but for a basic Excel user, this may be the most straightforward.
An even better way would be to learn how to create a single database with all of those monthly transactions in a single table, on a single tab, and then use Excel features such as the Pivot Table to extract monthly data, including totals. This lets Excel do the heavy lifting.