As the attached example will hopefully illustrate, I need to split a SumTotal by criteria used in the table.
I have run out of ideas after extensive reading and testing :-)
Torers
Excel Home 2013-8.1
As the attached example will hopefully illustrate, I need to split a SumTotal by criteria used in the table.
I have run out of ideas after extensive reading and testing :-)
Torers
Excel Home 2013-8.1
Populate J16 with the formula:then copy across and down.![]()
=SUMIFS(J$18:J$38,$I$18:$I$38,$I16)
Let me know if you have any questions.
Brushed up on GETPIVOTDATA![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks