this gives a total of 6...
=COUNTIFS(A2:A27,"*High school*",B2:B27,"*High school*")
edit: Ace, fromthe looks of it, your formula gives a 1 for if "either" parent have *High school*. I think the OP wanted "both Father and Mother have eitehr a "High School Degree" or "Some High School"
Last edited by FDibbins; 12-10-2012 at 04:50 PM.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks