I am looking for a way to get a total points for each race category.
ie: Total points earned for Asian students, white students Etc.
See attached Spreadsheet for data.
Also would there be a way to do this and return the totals for Asian Males, Asian Females, White Males, White Females, etc.
Thanks in advance
George
try this...
I made a table with the unique categories (copied B and removed dup's)
American Indian/Alaskan Native Asian Black/African-American Hispanic/Latino N/A Native Hawaiian/Pacific Islander Other White/Caucasian
Then I used this in G2 and copied down and across...
=SUMIFS($D:$D,$A:$A,G$1,$B:$B,$F2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbins
How did you get the individuals cells to calculate?
Im stuck on getting the total values for each race category
If you could repost the excel worksheet with the formulas it would be awesome
George
Breakdown of Race & Gender
=SUMIFS(D:D,A:A,"Male",B:B,"*White*")
Breakdown of just Gender
=SUMIF(A:A,"Male",D:D)
the * in the gender portion allows for matching that within the cell instead of having the whole cell having to equal that.. So make sure when replacing that portion for the other races that the *'s stay on each end.
Last edited by vamosj; 11-18-2013 at 05:54 PM.
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
or like this
see the attached
Thanks FDibbins
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks