Hi,
1st post here so be gentle, hopefully this is clear enough.
I have a list of questions with yes/no, met/not met answers. I need to do a formula to see how many answered what, see attachment.
I've tried, if & Vlookup but quite new to this so struggling
thank you
Welcome to the board.
Try the COUNTIF function.
HI,Originally Posted by Jonmo1
Sorry to be thick,
I need to know the number of yes from column E to the question in column B and then another column for the Met etc..... My attachment didn't make it clear but in my working doc, there are 10 different questions so I need to search B for the question that is in G then search E for the answer, which goes into column H-K
thanks
try this in H2 and drag toward right...
=COUNTIFS($B:$B,$G2,$E:$E,H$1)
EDIT: BTW, that formula requires that your values across H1 to K1 match the answers in column E.
SO, that means that "Met" be the same but in your sample it was "Met " with a trailing space which means it will NOT count those that Met the criteria UNLESS you change it to remove the trailing space. Hope that makes sense.
Last edited by Sam Capricci; 06-08-2018 at 11:56 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks