Summing specific cells!
 

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

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!

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