Ron,
Yes, they are in the same workbook.Yes, every month has its own
sheet.Yes,that is the thing I would like to do, is calculate both monthly
totals and ytd totals on a separate sheet. If that means that every month is
basically its own sheet, which I believe it is. Yes, every total is on the
same row (i.e. January monthly total is on B5, February is B5 on its sheet)
and the ytd is on the B6 row.
"Ron Coderre" wrote:

First, let's see if we can get a few more details about the data structure.

You mentioned that you have worksheets that you want to "bring together".

Do you mean that you have a separate sheet for each month and you want to
calculate both monthly totals and year-to-date totals on a separate sheet?

Are all of the sheets in the same workbook?

Are all of the numbers for a particular month in only one column or row?

Is there already a monthly total for each month somewhere in the workbook?
If YES, is it in the same place on each sheet (if you used multiple sheets)?

***********
Regards,
Ron

XL2002, WinXP


"eericclaptonfan" wrote:

Mr. Coderre,
Maybe this will help, I need to make a template for this not-for-profit and
I am having trouble with the formula for making the total contribution for
the month, and then adding to the next month's total so that there is a
current total for each month. Let us say for example that there is a group of
worksheets that you want to bring together. You take the first month, which
in this case is January, I then clicked the cell which in this case we will
call B5. The formula that I used was the following: =SUM(B3:B17) Is that
right so far? This gave me the total contributions for the month. I need to
come up with a formula that would enable me to move this total into the next
cell marked B6, because from there I need to take this total and apply to
every month so that there is a continuing running total. I have XL2003 . I
hope this helps the both of us. Any other help that you can give me would be
greatly appreciated. Eric Clapton Fan

"Ron Coderre" wrote:

I think you'll find it easier if you post a specific example of what you want
a formula to do, including the version of Excel and the basic structure of
the data:
(eg I have a column of numbers in Excel 2000 that I need to calculate an
average for)

That way you'll avoid being overwhelmed by all of the possibilites that
functions offer. You'd rather just be....whelmed, right?

***********
Regards,
Ron

XL2002, WinXP


"eericclaptonfan" wrote:

I am an extern in a not-for-profit organization. I need help with formulas
and do not know how or what to do? Please help me.