I have a pivot table that will vary from 4 to 5 columns when produced. It will place the data in from B5 to F5 if if 5 total columns are produced and from B5 to E5 if only the 4 total columns are produced. The last column is the total column in each scenerio.
I have another section where I take that data and and divide columns prior to the total column BY the total column to get a percentage.



A B C D E F
Count of Seizure NumberColumn Labels Row Labels1-3061-90>91Grand TotalCalifornia - West11Florida - Southeast22New Jersey - Northeast1135Texas - Central246Grand Total61714

What formula would I use for this?

Mike