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

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