Hi,
I have a report that creates multiple sheets. Each sheet has a total. I want to create a summary page that shows the totals from each of these sheets. Can anyone suggest how I could do this?
Thanks,
Tammy
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Tammy,
There are several ways to do this. One way would be to simply do the sums again. If you are replicating values and then summing those values, you can just use an NL(Sum) function or functions to sum the same values in a single cell.
On the other hand, you may need to sum something more complicated from your detail sheets, such as Excel calculations. On your summary sheet, you could replicate the same values used to produce your sheet names and then use the Excel ADDRESS function and INDIRECT functions to get the values from each sheet. Then you could sum these values and hide the replicated rows. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Thanks Hughes,
It did make sense enough to solve my problem. I was trying to sum excel formulas so the NL(Sum) wasn't a great option. I was not familiar with the ADDRESS and INDIRECT functions and in the end using the INDIRECT with worksheet named ranges solved my problem nicely. Again, thank you.
Tammy
Please sign in to leave a comment.