Summing specific cells!

  • Thread starter Thread starter jepoy_02
  • Start date Start date
J

jepoy_02

hey people!

i have a question. the chart is similar to below

Location Fuel Type Volume i
Liters
(18 locations) (13 types)


i need a formula that will sum the volume in liters of al
location-fuel type combinations. the sum will be displayed in
separate worksheet. also, will it work even when i add additiona
data? thanks
 
Try the pivot table approach. If you are on Excel 2003, convert the data
area into a LIST by means of Data|List|Create List before feeding the
Range spec to the PivotTable wizard. Otherwise, you'll need to define a
dynamic named range to capture the shrinking/expanding data.
 
Back
Top