sum and combine?

[cannedsoda]

I have a table that I need to combine the totals and items.

red 4
red 9
red 5
blu 9
blu 2
gre 8
gre 3

Can excel combine and add the totals to look like this?

red 18
blu 11
gre 11

 

[Paul B]

cannedsoda, something like this, with red in column A and numbers in B

=SUMIF(A1:A10,"red",B1:B10)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Ken Wright]

Pivot Table sounds like what you are after.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[cannedsoda]

Thanks, I read the help and saw that but couldn't find a way to get the
result without defining the value in the first column as there are hundreds
of different values there.

<DIV>&quot;Paul B&quot; &lt;[email protected]&gt; wrote in

 

[cannedsoda]

Never used pivot tables before.

<DIV>&quot;Ken Wright&quot; &lt;[email protected]&gt; wrote in

 

[cannedsoda]

pivot tables seems to be doing the trick. thanks.

<DIV>&quot;cannedsoda&quot; &lt;[email protected]&gt; wrote in message

 

[Gord Dibben]

http://www.contextures.on.ca/tiptech.html

Scroll down to P for pivot table instructions and assistance.


Gord Dibben MS Excel MVP

 

[Ken Wright]

The wizard does most of the work for you and it is probably the most
powerful feature that Excel has. Well worth the time and effort to learn.


Regards
Ken.........................