Hi,
I have two rows (representing response to question 1 and 2) with "Yes" and "No" values. The columns represent individuals. I need to calculate number of individuals said "Yes" at least to one question. How can i avoid double counting of "Yes" since given individual can say "Yes" to question 1 and 2 however adding them up will be double counting since it is just one individual. Thanks, a
Can you post a SMALL sample file and show us what result you expect?
A SMALL file will have about 20 rows and a few columns worth of data.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi, welcome to the forum
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
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
Hi, without sample worksheet, but i guess this is counting unique distinct customers with "Yes". See picture:
Untitled.png
Quang PT
Dear All, thanks for your support
I have attached sample file. I need to calculate how many people (out of 10) replied "Yes" to either question (question 1 or 2). It is easy to do when it is "Yes" and "No". But when it is "Yes" for both questions formula calculates it as 2 instead of 1 since it is just one person. Thanks
Try entering this formula in B4:K4Does this do what you want?Formula:
Please Login or Register to view this content.
Dave
Here's another.or this one.Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 11-02-2015 at 03:21 AM.
IN your attached file where you need answer and what is your expected result for that
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Many members are unable to see images in the *.png format.
If you need to post an image post it in the *.jpg format.
Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.
Thanks a lot FlameRetired, that is exactly what i needed. Thanks
You're welcome. Glad it does the job. Thanks for the feedback and the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks