Sum Cells in Multiple Worksheets at Different Positions
Hey everyone - 1st time poster here,
I have a question about summing a group of cells in multiple worksheets. I have multiple worksheets, each representing a different company. In each of these worksheets is a list of accounts (with account numbers and names in the same cell and the amount in the next column:
e.g., 121100 Cash 100,000
121101 Cash Equivalents 50,000
and so on . . .
The account coding represents the type of account and the number of accounts is not consistent in each workbook - but the formatting is.
In one fell swoop, I would like to be able to sum the values of all the accounts starting with "121*" from each tab. Using =SUM('Sheet1:Sheet5'!B3:B10) (<-- example) wouldn't work because each worksheet has the accounts I'm looking for at different positions down the list.
Any thoughts on how I can do this?
Video Tutorials / Excel Dashboards Reports