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.

Ah! That's like asking the question about life, the universe and
everything. To simplify things there are inputs (from the user), the
manipulation of data (formula) and outputs (either derived data or
graphics.) The art of spreadsheet design is to understand the inputs and
outputs required by the Client - although this may go through a number of
versions before the Client realises what he may really want.

If you are really new to spreadsheeting I would suggest you get yourself on
a beginners course. That will give you a start at understanding
spreadsheets - what they are and what they can do.

If you need more specific help please feel free to ask away.

Regards.

Bill Ridgeway
Computer Solutions

"eericclaptonfan" wrote in
message ...
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.

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.

Mr. Ridgeway,
Thank-you for your reply, I should have been a little more specific, I am
making a template for the aforementioned organization, I am trying to come up
with a formula that will let me perform the tasks of taking the contributions
column (total) for the month and then taking that and making it add to the
next months balance. I hope that is clear enough. Any help you can give me
would be greatly appreciated.

"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.

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.

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.

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.