Budget Question
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?
|