sum and combine?

C

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
 
P

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
 
K

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 :)
------------------------------­------------------------------­----------------
 
C

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
 
K

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.........................
 
Top