![]() |
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 :) |
She said that your not the only one but your the best Bradley
|
She said I love a the way you move I love the way you rap, bap bap
|
Give it to me 1 time, give it to me 2 time, give it to me 3 time
|
you just need to highlight andt click auto sum.. then all is up!
|
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 |
Quote:
|
Thanks, that works but I have to manually enter how many lines the item appears, I guess its easier than using the calculator :)
|
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