Thread: Count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default Count

I want to count the number of cells in a column with 1-5 in them. The other
cells in this same column are "false" and I don't want those to be counted.
I've tried =count(p1:p20) and =countif(p1:p20,"false"), but neither of these
works.

Please help.