LinkBack URL
About LinkBacks
Karen57 
Hi, without sample worksheet, but i guess this is counting unique distinct customers with "Yes". See picture:
Untitled.png
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:
=--OR(COUNTIFS($B$1:B$1,B$1,$B$2:B$2,"yes"),COUNTIFS($B$1:B$1,B$1,$B$3:B$3,"yes"))
Dave
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.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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
Register To Reply
Bookmarks