How can I have a formula reference the total of a pivot table when the data changes?
Right now if I add data, the formula I am using is just referencing a specific cell and doesn't adapt to the changes.'
Thank you
How can I have a formula reference the total of a pivot table when the data changes?
Right now if I add data, the formula I am using is just referencing a specific cell and doesn't adapt to the changes.'
Thank you
Last edited by JCarollo765; 12-14-2016 at 05:17 PM. Reason: Figured it out....
JCarollo765:
Few ways to do this come to mind:
Name the range containing and overlapping the total. Do a MAX formula to pick out the largest value, likely the total.
Another way: Create a SUMIF function, referring to a unique label you created in an adjacent column. That can pick up the total from a moving target.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks