 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Finding the percent of Yes answers pt 2
The initial formula, =COUNTIF(H4:H33,"Yes")/COUNTA(H4:H33), works great. But, no let's say that besides Yes and No answeres, there are n/a answers. How do I account for this in the formula. Excel XP SP2 If you only want to include "Yes" and "No" answers in your calculations, here are two options: =COUNTIF(H4:H33,"Yes")/(COUNTA(H4:H33)-COUNTIF(H4:H33,"n/a")) or =COUNTIF(H4:H33,"Yes")/SUM(COUNTIF(H4:H33,{"Yes","No"})) Does that help? *********** Regards, Ron XL2002, WinXP > The initial formula, =COUNTIF(H4:H33,"Yes")/COUNTA(H4:H33), works great. > But, no let's say that besides Yes and No answeres, there are n/a answers. > How do I account for this in the formula. > > Excel XP SP2 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.