Hi
I need to create a summary sheet which pulls data from 12 monthly tabs. If I use the normal consolidate function I am only able to consolidate by one criteria e.g. customer number.
I need to try and consolidate by customer and by a product to show “Energy Surcharge” on a separate line – is this possible?
e.g.
3152 Customer C 512246 energiKare(TM) 15 17.32 1083.44
3152 Customer C 512247 energiKare(TM) 4 2.53 142.68
3152 Customer C 512267 energiKare(TM) 1 0.34 21.46
3152 Customer C 512272 energiKare(TM) 8 27.74 1753.16
3152 Customer C 99999999 Energy Surcharge 0 0 2145.02
I need this to show on the summary sheet as:
3152 Customer C Glass 28 47.93 3000.74
3152 Customer C Energy Surcharge 0 0 2145.02
Everything other than Energy Surcharge should be class as glass.
Can this be done?
Bookmarks