View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert-Alpha[_2_] Robert-Alpha[_2_] is offline
external usenet poster
 
Posts: 10
Default count only certain cells

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