View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Count a range of cells using an IF

Yes. But I was thinking it's a clearer way to implement the criteria
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"Pete_UK" wrote in message
...
Max,

As A1 can never be less than A1 then it will not be included in the
count, so you can include it in the range as per your first post.

Pete