So, my problem is this. I can't figure out what formula to use to add the data. In Column A I have a Students name, In Column B I have the colour of the marbles, and in C I have the amount of that colour. How do I creat a Sum of all the Specific colours?
Student Colour Number Steve Blue 4 Red 12 Green 16 Dan Blue 8 Yellow 10 Red 5 Tony Green 6 Yellow 9 Red 14
try this
Formula:
Please Login or Register to view this content.
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
Pivot table for your Colour column and Number column.
Make your number as SUM, then it will list down all your color and sum value.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks