For some of my actual cost fields in my budget (e.g. Groceries, Dining Out,
etc.) I want to be able to accumulate totals in subordinate spreadsheets and
have the accumulated totals show up in the "master" spreadsheet. My "master"
has columns for projected costs and actual costs, and columns for the
differrence. So for example, I'd like to accumulate daily grocery purchases
in a subordinate groceries spreadsheet, have the new total post to the
"master's" Actual Groceries cost field, and have the "master" compute the
difference Can anyone help?

In your "Master" spreadsheet, under the groceries column enter the formula:
=SUM(Groceries!C:C)
With the assumption that your have the cost of groceries in Column C.

Did I understand and answer your question correctly?

Hope this helps, Jim
--
I appreciate any feedback.


"dmacgregor" wrote:

For some of my actual cost fields in my budget (e.g. Groceries, Dining Out,
etc.) I want to be able to accumulate totals in subordinate spreadsheets and
have the accumulated totals show up in the "master" spreadsheet. My "master"
has columns for projected costs and actual costs, and columns for the
differrence. So for example, I'd like to accumulate daily grocery purchases
in a subordinate groceries spreadsheet, have the new total post to the
"master's" Actual Groceries cost field, and have the "master" compute the
difference Can anyone help?

Thanks but does this formula capture the subordinate spreadsheet's
accumulated grocery total? And could it work if the subordinate has columns
for other things, like date of purchase, store, etc?

I know I'm making it complicated but capturing such additional detail will
be helpful for other reasons.

"J Sedoff" wrote:

In your "Master" spreadsheet, under the groceries column enter the formula:
=SUM(Groceries!C:C)
With the assumption that your have the cost of groceries in Column C.

Did I understand and answer your question correctly?

Hope this helps, Jim
--
I appreciate any feedback.


"dmacgregor" wrote:

For some of my actual cost fields in my budget (e.g. Groceries, Dining Out,
etc.) I want to be able to accumulate totals in subordinate spreadsheets and
have the accumulated totals show up in the "master" spreadsheet. My "master"
has columns for projected costs and actual costs, and columns for the
differrence. So for example, I'd like to accumulate daily grocery purchases
in a subordinate groceries spreadsheet, have the new total post to the
"master's" Actual Groceries cost field, and have the "master" compute the
difference Can anyone help?

Do I understand you when you are saying that you would like to have a
summation of your groceries on a day-to-day basis in your "Grocery" tab (And
so on with your other tabs..), and then in your "Master" tab, reference those
totals? If so and you want to total each daily total (so you just have one
number, the summation, for groceries), then all you need to do is what I
mentioned befo in a cell on your "Master" tab use the =sum() function,
referencing your "Grocery" tab and the Column that contains each day's total.

In your "Master" spreadsheet, under the groceries column enter the formula:
=SUM(Groceries!C:C)
With the assumption that your have the cost of groceries in Column C.

As long as you do not store any other data in Column C (assuming that is
where your daily totals are located (I'm sure you know that you can change
the C's to any letter to reflect which column the daily totals are truly
in)), the equation above will ignore any data not in Column C, so you are
still able to store other data, as long as it is in a different column, be it
things like date of purchase, store, etc.

Am I understanding what you are asking?

Hope this helps, Jim
--
I appreciate any feedback.