View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jafferi[_2_] Jafferi[_2_] is offline
external usenet poster
 
Posts: 22
Default Count text on certain date

I need help to get system to get result by counting. for example based on the
'Data' below, there's a row of dates in column A and currency in Column B.

In a summary page, I have these

Date
6/3/08 -- The questions is, how do I fomulate the cell to count for me the
number of AUS for the said date?


Data
****
A B
------------------
6/3/08 AUS
6/3/08 DMK
6/3/08 DMK
6/3/08 DMK
6/3/08 DMK
6/3/08 DMK
6/3/08 DMK
6/3/08 AUS
6/3/08 DMK
6/3/08 OSM
6/3/08 OSM