Here are 2 ways:

Use a Pivot Table where the layout would be:
ROWS: Category
DATA: Sum of Totals

or a formula like this would do it:

=SUMIF(C1:C100,"food",D1:D100)
returns the total for "food" lines.

Adjust range references to suit your situation.

Does that help?

***********
Regards,
Ron


"mark d davis" wrote:

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?