Take a look at pivot tables.

See http://www.contextures.com/xlPivot01.html for a starter.

--
HTH

Bob Phillips

"jepoy_02" wrote in
message ...

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!


--
jepoy_02
------------------------------------------------------------------------
jepoy_02's Profile:
http://www.excelforum.com/member.php...o&userid=24358
View this thread: http://www.excelforum.com/showthread...hreadid=466721