Hi
Just hoping if someone could help me.
I have a worksheet that has 8 criteria on it and the boxes are filled out 'yes' or 'no'.
I want to find
1 - if all criteria are all answered yes, how do i make a formula to show me in a separate column that all answers are yes?
2- if some answers to the criteria are no, how do i show this in the seperate column?
3 - how can i show percentages of yes and no's eg. 50% of programs had 7out of criteria 8
thanks
Something like this would give you your count of yes/no's. You should be able to calculate the rest from that.
=COUNTIF(A1:H1,"Yes")
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thanks so much Dom. Yep that works perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks