 |
 | 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 / Worksheet Functions / June 2006Yet another issue
At this point Excel hates me, I can feel it. So this is what my next issue is. I have column B which the user places an "x" in the cell that corresponds with a day of the week in column A. I have column C that has an "x" placed into the cell when a certain code is inputed into column D, What I am trying to do is have a cell at the bottom, give me a percentage of the X's between column B & C. Can anyone shed light on this for me please.. Thank you ahead of time! Excel loves you!! It just has difficulty expressing that love. Use COUNTIF(). COUNTIF(B1:B100,"X") and the similar for column C. Then take the ratios, etc.  SignatureGary''s Student > At this point Excel hates me, I can feel it. So this is what my next issue > is. I have column B which the user places an "x" in the cell that corresponds [quoted text clipped - 4 lines] > > Thank you ahead of time! No success with that formula unless again I am doing it wrong. I basically need to show a percentage of X's from column C vs column B > Excel loves you!! It just has difficulty expressing that love. > [quoted text clipped - 10 lines] > > > > Thank you ahead of time! My explanation was a little sketchy. Let's say we have this data from B1 thru C20: 0 0 0 X 0 0 X 0 0 0 0 X X 0 0 0 0 0 X 0 0 0 0 X 0 0 X 0 0 0 0 0 X 0 0 0 0 X 0 0 and in E1 the formula =COUNTIF(B1:B100,"X") and in F1 the formula =COUNTIF(C1:C100,"X") E1 shows 5 and F1 shows 4 The total X's are 9 and the percent from column B is 5/9 or about 55.55% The percent from column C is 4/9 or about 44.44%. The ratio of B to C is 5/4 or 1.25/1 Let me know if this helps. SignatureGary''s Student > No success with that formula unless again I am doing it wrong. I basically > need to show a percentage of X's from column C vs column B [quoted text clipped - 13 lines] > > > > > > Thank you ahead of time! =COUNTIF(C:C,"X")/COUNTIF(B:B,"X") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > No success with that formula unless again I am doing it wrong. I basically > need to show a percentage of X's from column C vs column B [quoted text clipped - 15 lines] > > > > > > Thank you ahead of time! Thanks Bob SignatureGary''s Student > =COUNTIF(C:C,"X")/COUNTIF(B:B,"X") > [quoted text clipped - 30 lines] > > > > > > > > Thank you ahead of time! |
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
|
©2009 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.