 |
 | 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 / October 2006HELP COUNTING
XP XP P XP P XP P P P XP XA XP XP XA XA P P P P P P XA XA XA XA XA XP XP P XP P XP P P P XP XP XP XP P XA P P P P P P XA UXA P P XA P P P P UXA UXA P P P P XA P P P P P UXA P UXA P P P XA UXA XA XA P P P P P P XA UXA XA XA XA XA XA P P P P XA P XA XA XA UXA XA XA XA P P P XA P P P P P P P P P P XA XA XA XA XA XA XA XA XA XA XA XA P UXA P P UXA P P P P P P P P P P XA P P P I NEED A FORMULA TO COUNT THE P'S,AND XP'S TOGETHER AND THE XA'S AND UXA'S TOGETHER. ANY HELP???? PLEASE???? =COUNTIF("A1:K30","P")+COUNTIF("A1:K30","XP") HTH Kostis Vezerides > XP XP P XP P XP P P P XP XA XP XP > XA XA P P P P P P XA XA XA XA XA [quoted text clipped - 11 lines] > I NEED A FORMULA TO COUNT THE P'S,AND XP'S TOGETHER > AND THE XA'S AND UXA'S TOGETHER. ANY HELP???? PLEASE???? Count them together, or count the P and XPs adjacent? Former =SUMPRODUCT(COUNTIF(A1:M12,{"P","XP"}))  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > XP XP P XP P XP P P P XP XA XP XP > XA XA P P P P P P XA XA XA XA XA [quoted text clipped - 11 lines] > I NEED A FORMULA TO COUNT THE P'S,AND XP'S TOGETHER > AND THE XA'S AND UXA'S TOGETHER. ANY HELP???? PLEASE???? If each letter or letter combination is in a seperate cell, then you can use a countif statement. However, if all of the data you listed is in the same sell then: This should return the number of "XP" plus the number "P". =(LEN(A1)-LEN(SUBSTITUTE(A1,"XP","")))/2+LEN(SUBSTITUTE(A1,"XP",""))-LEN(SUBSTITUTE(SUBSTITUTE(A1,"XP",""),"P","")) This should return the number of "UXA" plus the number "XA". =(LEN(A1)-LEN(SUBSTITUTE(A1,"UXA","")))/3+(LEN(SUBSTITUTE(A1,"UXA",""))-LEN(SUBSTITUTE(SUBSTITUTE(A1,"UXA",""),"XA","")))/2 HTH, Paul > XP XP P XP P XP P P P XP XA XP XP > XA XA P P P P P P XA XA XA XA XA [quoted text clipped - 11 lines] > I NEED A FORMULA TO COUNT THE P'S,AND XP'S TOGETHER > AND THE XA'S AND UXA'S TOGETHER. ANY HELP???? PLEASE???? Hopefully you dont need this because its for a project at school or something similar :) > XP XP P XP P XP P P P XP XA XP XP > XA XA P P P P P P XA XA XA XA XA [quoted text clipped - 11 lines] > I NEED A FORMULA TO COUNT THE P'S,AND XP'S TOGETHER > AND THE XA'S AND UXA'S TOGETHER. ANY HELP???? PLEASE???? Thanks for the Help, I got the answer On 10/19/06 2:08 PM, in article 1161281324.315320.104430@k70g2000cwa.googlegroups.com, > Hopefully you dont need this because its for a project at school or > something similar :) [quoted text clipped - 14 lines] >> I NEED A FORMULA TO COUNT THE P'S,AND XP'S TOGETHER >> AND THE XA'S AND UXA'S TOGETHER. ANY HELP???? PLEASE???? What was your answer? SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Thanks for the Help, I got the answer > [quoted text clipped - 19 lines] > >> I NEED A FORMULA TO COUNT THE P'S,AND XP'S TOGETHER > >> AND THE XA'S AND UXA'S TOGETHER. ANY HELP???? PLEASE???? |
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.