Clarification
this didnt seem to work. I copied and past the formula. and tried typing it
in. cant seem to get it to work. any other ideas.
"Ron Coderre" wrote:
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?
|