Linking totals in Excel

[Guest]

I want to link totals from a spreadsheet to a summary total block. I would
like to structure the detail totals to take care of all possible categories.
(One summary total for each category). The detail data from this weeks
spreadsheet may not contain data for all categories. How can I have a "place
holder for each total"? Next week the summary total that was empty will be
full.
I have used nested sub totals but can't figure out how to link those without
doing it every time the weekly spread is run.

 

[R.VENKATARAMAN]

if ;you click edit-copy a cell(e.g A1) and then go to another cell (e.g.
F10) click edit pastespecial and click paste link(at the bottom of paste
special window) the two cells are linked. that is if A1 changes F10 also
will change.

 

[Guest]

What if I have a Group of Categories say 25 categories. I want always to show
all 25 categories on the report. There will not be numbers in all categories
on all weeks. I want to show zeros for the empty categories each week. I
used subtotals and I dont get totals for the empty categories since there is
nothing there.

 

[JulieD]

Hi Robert

I would look at using the SUMIF function
=SUMIF(Week1!$A$1:$A$100,"Category 1",Week1!$B$1:$B$100)

to give all of the weekly totals in the summary page for each category - if
you have the categories listed on the summary sheet instead of typing
Category 1 you can refer to it and then just fill the formula every which
way.

Hope this helps
Cheers
JulieD