98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sum if formula
Sum if formula
Resolved · Low Priority · Version 365
Wed 23 Nov 2022, 16:38Delegate Aneela said...
Aneela has attended:
Excel Intermediate course
Sum if formula
is there a quick way for formulas to update when looking up one tab to a new tab in a sum if formula?
Thu 24 Nov 2022, 09:45Trainer Marius said...
RE: sum if formula
Hello Aneela,
Thank you for your question. All formulas in Excel will update live, even those linking to data on other tabs.
The only time formulas don't update live is if calculations are set to Manual. You can check this by going to:
Formulas > Calculation Options. Here, check that 'Automatic' is selected.
I hope this helps.
Kind regards
Marius Barnard
STL
Thu 1 Dec 2022: Automatically marked as resolved.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |
