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.

jepoy_02 wrote:
hey people!

i have a question. the chart is similar to below

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


i need a formula that will sum the volume in liters of all
location-fuel type combinations. the sum will be displayed in a
separate worksheet. also, will it work even when i add additional
data? thanks!