If you want the items on Sheet1 summarized on Sheet2, then on Sheet2 the
formula would be more like this:

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

and if on Sheet2:
A1: Food
B1: =SUMIF(Sheet1!C1:C100,A1,Sheet1!D1:D100)
returns the total of Food items from Sheet1

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


"Ron Coderre" wrote:

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?