Thread: What is wrong with formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMF in MN TMF in MN is offline
external usenet poster
  
Posts: 12
Default What is wrong with formula?
A B C
8/1/06 8/1/06 2
8/2/06 8/2/06 1
8/3/06 8/3/06 2
8/3/06
8/1/06

I need a formula to count how many dates in the list are for 8/1, 8/2, etc.
I tried COUNTIF(A1:A5,=b1) and get 0 value
Reply With QuoteReply With Quote