Another easy excel question - GoFuckYourself.com

mkx · 11-12-2006, 06:29 PM

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 · 11-12-2006, 06:56 PM

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

mkx · 11-12-2006, 06:57 PM

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

mkx · 11-12-2006, 07:13 PM

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

shekinah · 11-12-2006, 07:19 PM

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

Trixxxia · 11-12-2006, 07:28 PM

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 · 11-12-2006, 07:38 PM

Quote:

Originally Posted by TopBucksTrixxxia

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 · 11-12-2006, 07:46 PM

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

marketsmart · 11-12-2006, 09:14 PM

they didn't teach that to you in highschool?

11-12-2006, 06:29 PM	#1
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Another easy excel question 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

11-12-2006, 07:19 PM	#5
shekinah Confirmed User Join Date: May 2006 Posts: 8,452	you just need to highlight andt click auto sum.. then all is up! __________________ [Web Design \| Development \| Programming \| Content Writing ] ICQ: 238-890-469

11-12-2006, 06:56 PM	#2
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	She said that your not the only one but your the best Bradley

11-12-2006, 06:57 PM	#3
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	She said I love a the way you move I love the way you rap, bap bap

11-12-2006, 07:13 PM	#4
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Give it to me 1 time, give it to me 2 time, give it to me 3 time

11-12-2006, 07:28 PM	#6
Trixxxia Confirmed User Industry Role: Join Date: Aug 2004 Location: Montreal, Canada Posts: 5,600	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

11-12-2006, 07:46 PM	#8
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Thanks, that works but I have to manually enter how many lines the item appears, I guess its easier than using the calculator

11-12-2006, 09:14 PM	#9
marketsmart HOMICIDAL TROLL KILLER Industry Role: Join Date: Dec 2004 Location: Sunnybrook Institution for the Criminally Insane Posts: 20,419	they didn't teach that to you in highschool?