I'm sure this is quite simple, but I cant seem to figure it out. I typed my example below.
Basically, I need to tally the number for each size. So how many 8" items are there? 5" items etc.?
Item #1 5" 1000
Item #2 8" 500
Item #3 3" 750
Item #4 8" 2000
Item #5 5" 250
(Whats the formula for this part)
Total 5" 1250
Total 8" 2500
Total 3" 750
With B1:B5 containing your sizes, and B8:B10 also containing the sizes (not including the word Total - put that in column A), then you can put this formula in C8:
=SUMIF(B$1:B$5,B8,C$1:C$5)
then copy down to C10.
Hope this helps.
Pete
Assuming "Items #1" is in column A, "5"" is in column B, and "1000" in column C:
=SUMIF(B:B,"5""",C:C)
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Assuming your data start in A2(Item #1)
=SUMIF(B2:B100,"5"",C2:C100)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
or with an pivot table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Pivots are better where more than absolute basic functionality is required.
Thank you everyone, problem solved!
I really like that Pivot Table, I might have to look further into that in the future!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks