View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mark d davis
 
Posts: n/a
Default EXCEL.SUM OF DIFFERENT COLUMS AND LINES ON DIFFERENT SHEET REPEAT

if sheet one colum c has tobacco,gas,food, ect. and colum d has totals of day
and there repeated lines like this down the colum. how do I get the sum of
all lines that say tobacco, or gas, or food, ect to auto compute on another
sheet?