Summing from different sheets...

[floyd605]

I am trying to do something relatively simple, but hard to explain. Here goes:

I have 13 sheets: 1 for each month and then a total sheet. This is for our church. We are tracking the giving of each individual in the church for the whole year. We want to keep a running total of how much each person is giving on sheet 13 (the "Total Giving" sheet). How can I program the workbook so that each time "John Doe" is in column A that the amount he gives (in the adjacent column B cell) is added to his total on sheet 13?

I hope this makes sense...

Thanks in advance for any help!
floyd605

[NBVC]

Assuming the sheets are named with some consecutively numbered pattern, like Sheet1, Sheet2, ect... or Week1, Week2, etc...

Then try something like:

Please Login or Register  to view this content.

Replace "Sheet" with your sheeetname prefix...

INDIRECT(1&":"&13) represents sheet 1 to sheet 13....

A2:A1000 and B2:B1000 would be the size of your databases in each sheet.. adjust as necessary... to accomodate also for new entries... making sure you have at least covered the largest sheet database.

And A2 represents first name on summary sheet to search for

Formula can be copied down.

[floyd605]

I get this error:

#REF!

[floyd605]

The sheets are named like this:

Jan10,Feb10,Mar10,etc.
The total sheet is named GivingReport

[NBVC]

Try:

Please Login or Register  to view this content.

which assumes you have sheets Jan10 to Dec10. If not, change 12 to coincident ending month number...

If you want to be a bit more dynamic about the number of sheets, then you can use something like:

Please Login or Register  to view this content.

Where J1 would contain a number representing the last month number to account for in the sheet numbering..

furthermore, if J1 were to contain an ending date to correspond to sheets... then

Please Login or Register  to view this content.