GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Another easy excel question (https://gfy.com/showthread.php?t=676486)

mkx 11-12-2006 06:29 PM

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

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 (Post 11300238)
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?


All times are GMT -7. The time now is 10:10 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123