Another easy excel question

[mkx]

Basically I need to add the total quantities per item name:

What I have is:

Column A Column B
Item1 5
Item1 11
Item1 13
Item2 3
Item2 1
Item3 4
Etc

I need it to add up the totals somewhere, like in column C or C and D?
Column C Column D
Item1 29
Item2 4
Item3 4

Hope someone can help

[mkx]

She said that your not the only one but your the best Bradley

[mkx]

She said I love a the way you move I love the way you rap, bap bap

[mkx]

Give it to me 1 time, give it to me 2 time, give it to me 3 time

[shekinah]

you just need to highlight andt click auto sum.. then all is up!

[Trixxxia]

Well you can sort your cells by item or you can just type the equation:

So if ITEM1 is in A1 thru A3 (but the numbers are in B) then wherever you want (doesn't need to be in C) you put "=Sum(B1:B3)" without the quotes

[WarChild]

Well you can sort your cells by item or you can just type the equation:

So if ITEM1 is in A1 thru A3 (but the numbers are in B) then wherever you want (doesn't need to be in C) you put "=Sum(B1:B3)" without the quotes

Just to add to this, if you want to have the item "name" listed in front of the sum make the formula the following "=A1&" "& SUM(B1:B3)"

[mkx]

Thanks, that works but I have to manually enter how many lines the item appears, I guess its easier than using the calculator

[marketsmart]

they didn't teach that to you in highschool?