fernipascual
Board Regular
- Joined
- Sep 3, 2009
- Messages
- 76
Hi all:
I have a pivot table and SUMIFS in separate tabs that calculate off of the pivot table. I added a metric to the pivot table and, of course, everything shifted one column to the right. My SUMIFS are now looking at the wrong ranges. I built a lot of different formulas with many different ranges. I knew this would happen so I'm working off a copy of the original file.
Is there a way to correct the ranges without having to modify every formula? Any tips on how I should develop formulas in the future to prevent this from happening when I modify a pivot table?
I'm on Microsoft 365. No knowledge of visual basic for what it's worth.
Much appreciated!
I have a pivot table and SUMIFS in separate tabs that calculate off of the pivot table. I added a metric to the pivot table and, of course, everything shifted one column to the right. My SUMIFS are now looking at the wrong ranges. I built a lot of different formulas with many different ranges. I knew this would happen so I'm working off a copy of the original file.
Is there a way to correct the ranges without having to modify every formula? Any tips on how I should develop formulas in the future to prevent this from happening when I modify a pivot table?
I'm on Microsoft 365. No knowledge of visual basic for what it's worth.
Much appreciated!