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

referring subtotal formula

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

ResolvedVersion 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

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.