Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Totalling Separate Worksheets
I am the Financial Secretary at my church. I have a worksheet set up for the
weekly deposits. I then have 20+ worksheets for individual member contributions that they need each year for tax purposes. How can I total those 20+ pages and see if that total matches the total contribution worksheet? Thanks for your help. |
#2
|
|||
|
|||
Hi
is there a cell on each of the 20+ sheets that contains the total (ie in cell D27 of every sheet i'll find the total contributions for the person), if so, then summarising them can by done by the use of a formula like =SUM(firstsheetname:lastsheetname!D27) this will sum everything in cell D27 between the first sheet on the left and the last sheet on the right. If however, they're not set up like this, maybe if you could reply with a description of how they are set up we might be able to come up with a workable solution. (please just type out your description, don't attach a workbook). Regards JulieD "huskggie" wrote in message ... I am the Financial Secretary at my church. I have a worksheet set up for the weekly deposits. I then have 20+ worksheets for individual member contributions that they need each year for tax purposes. How can I total those 20+ pages and see if that total matches the total contribution worksheet? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of worksheets | Excel Discussion (Misc queries) | |||
Can I view separate worksheets at the same time? | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |