I have an excel sheet with 100 rows. In each box of column C there is a +, - or NA indicating my students performance on an assignment. I need a formula that will count the number of + and divide it by the number of - and + (and ignoring the NA).
For example, in column C, there are 88 + marks, 11 - marks and 1 NA mark. I'd like the formula to be able to do this for me without me having to count it each time. The result would be 88/99=.88888 or 88.9%. Any ideas?
How about:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Try something like this (adjust ranges as needed)...
=COUNTIF(A1:A11,"+")/SUM(COUNTIF(A1:A11,{"+","-"}))
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
Perhaps
=COUNTIF(A1:A11,"+")/COUNTIF(A1:A11,"<>NA"))
Jonmo, slick(OP said "there is a +, - or NA", so as long as that holds
)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks