Thread: Please help!! Countif formula doesnn't work with text format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default Please help!! Countif formula doesnn't work with text format
"shirley_kee" wrote....
The formula you gave me doesn't seem to work.
=SUMPRODUCT(--(A1:A4=A1))

Worked for me. Based on your sample it returns 2.

Biff


Reply With QuoteReply With Quote