Thread: count function not working, keeps displaying 0
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
  
Posts: 915
Default count function not working, keeps displaying 0
Kimmie wrote:
So with this formula and example the answer is 5; however, is there a way to
use a formula to count similiar data. For instance,

Rec 21 will have a count of 2 in the next column because it appears 2.
Rec 24 will have a count of 1 in the next column because it only appears once.

Thanks for your assistance!

Try
=COUNTIF($H$1:$H$5,H1)
Reply With QuoteReply With Quote