Hi,

Are these manually entered subtotal lines - meaning did you type in a
SUBTOTAL formula yourself? Are the subtotal lines generated by the Data,
Subtotal command? Are the subtotal lines generated by a Pivot Table?

Show us some data and what you would want as the result based on that sample
data.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jennifer" wrote:

What function could I use if I want the info in the column to the right of
the subtotaled column to always equal the subtotal below it?
--
Jennifer