Substitute formulas

Resolved · Urgent Priority · Version 2011 (Mac)

Sun 26 May 2013, 11:19 Delegate Emma said...

Emma has attended:
Excel Intermediate course
Effective Communication Skills course
Excel Advanced - Formulas & Functions course

Substitute formulas

Hello,

I have a doc with almost 1,000 lines of data, I have set up totals (=sum(xxx) running all the way through it. I would like to change this to subtotals, (=Subtotal (9,XXX:XX). So I can subtotal at the bottom of the column without doubling counting my subtotals.
Is there a quick way of doing this?
Can I find replace formulas, or substitute formulas as opposed to going through it one, one by one?
I'm on a mac, excel 2011..

Thanks Emma

Tue 28 May 2013, 09:16 Trainer Gary said...

RE: Substitute formulas

Hi Emma

Thanks for getting in touch. You should be able to perform a "Find and Replace" action to achieve this.

In Excel 2011, click the triangle in the Search box at the upper right corner of the window. Choose Replace.

In "Find what" put your initial text (your SUM function). In "Replace with" put the new text (your SUBTOTAL function).

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 3 Jun 2013, 10:16 Trainer Cindy said...

RE: Substitute formulas

Hello Emma,

I am currently going through our forum to clear out any active questions. Can you please tell me whether you have managed to resolve this problem?

If not, please reply within five days so I can contact a trainer who can help you, otherwise this question will be marked as Resolved.

Thank you for your assistance.

Regards
Cindy