referring subtotal formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Referring to a subtotal in a formula

Referring to a subtotal in a formula

resolvedResolved · High Priority · Version 2003

Johsua has attended:
Excel Advanced course

Referring to a subtotal in a formula

I have set subtotals into a large table of data, and wish to use a formula that refers to the subtotal of a column. The formula is a simple one that creates a percentage value of the figures higher in the same column as the subtotal value. The issue is that the table will gain data and have data moved around, thus I need a formula that will always refer to the subtotaled cells no matter where they get placed or what row they end up on with data manipulation. This is for a report that will allow my company to calculate how we bill a client, so it must be a reliable one, even at the cost of being extremely complex.

Josh

RE: Referring to a subtotal in a formula

Hi Josh

From what you outline the solution may well be a relatively short amount of work or more require more effort.

Please email us with some example files outlining what you are trying to do and we will then be abel to establish the scope of work and rate for completing it.

Kind regards

Jacob

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips


Server loaded in 0.08 secs.