Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > HELP COUNTING
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 2
Default HELP 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????

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 751
Default HELP COUNTING
=COUNTIF("A1:K30","P")+COUNTIF("A1:K30","XP")

HTH
Kostis Vezerides


Pat Brewington wrote:
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????

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 10,593
Default HELP COUNTING
Count them together, or count the P and XPs adjacent?

Former

=SUMPRODUCT(COUNTIF(A1:M12,{"P","XP"}))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pat Brewington" wrote in message
news:C15D2D28.B27%pbrewington@youthservicesagency. org...


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????



Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 1,311
Default HELP COUNTING
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


"Pat Brewington" wrote in message
news:C15D2D28.B27%pbrewington@youthservicesagency. org...


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????



Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 16
Default HELP COUNTING
Hopefully you dont need this because its for a project at school or
something similar :)

Pat Brewington wrote:
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????

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique values giantwolf Excel Discussion (Misc queries) 4 August 28th 06 01:31 PM
conditional counting with Excel LeicaElmar Excel Worksheet Functions 1 October 17th 05 10:23 PM
Counting rows, then counting values. Michael via OfficeKB.com Excel Discussion (Misc queries) 7 August 4th 05 10:57 PM
Counting names in a column but counting duplicate names once TBoe Excel Discussion (Misc queries) 9 May 11th 05 11:24 PM
Counting... Patrick G Excel Worksheet Functions 3 February 23rd 05 10:05 PM


All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement