Thread: count only certain cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default count only certain cells
Maybe

=COUNTIF(A1:A11,4)

Mike

"Robert-Alpha" wrote:

how do i count only cells with a specific value in it...for ex., in the list
below i only want to count the cells with number 4 in them.. =3
4
4
4
5
5
5
2
2

Reply With QuoteReply With Quote