Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
805
Views
Topic starter
Hi,
If I have a sumif formula such as below, how do I prevent it from changing if/when I sort my data? Do I have to reapply the formula all over again?
=SUMIF('Parking Employee Contribution'!$A$5:$A$17,'Parking '!$A9,'Parking Employee Contribution'!$O$5:$O$17)
Thanks,
Brooke
Posted : 09/05/2017 2:18 am
Hi Brooke
The formula should not change if it is just sorting the data.
If it is changing, then maybe you can attach a sample for us to take a look.
Sunny
Posted : 09/05/2017 3:07 am
Hi Brooke,
There is a bug related to sorting.
Is the formula entered in 'Parking ' sheet? If so, remove the sheet name from this reference: 'Parking '!$A9, leave only $A9.
It should work better.
Posted : 09/05/2017 3:27 am
Topic starter
Removing the sheet name 'Parking' worked.
Thank you so much,
Brooke
Posted : 09/05/2017 6:19 am
