Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Dear experts,
I've a worksheet with data in Column A to Column F. Column A is for dates and column B is for names. I list some examples below: 12 Jan 08 Peter Ho Leung 22 Feb 08 Mary Kwan Yim 28 Mar 08 Peter Mung Ching 30 Apr 08 June Liew 3 Feb 08 June Tam Ho 13 Apr 08 Peter Lan Chi 26 May 08 Monica Cheung 27 Feb 08 Peter Cheng Firstly, I want to count how many records in Feb 08. Secondly, I want to count how many records with the name "Peter". I try to use the formulas below but they don't work. =COUNTIF(A1:A8,"*Feb*") and =COUNTIF(B1:B8,"Peter*") Please advise. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Records | Excel Worksheet Functions | |||
Count Unique Records | Excel Worksheet Functions | |||
Count certain records between dates | Excel Discussion (Misc queries) | |||
count of different type records | Excel Worksheet Functions | |||
Count Records Between A-K and L-Z | Excel Worksheet Functions |