Thread: Count a range of cells using an IF
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Count a range of cells using an IF
If you include the A1 within the quotes it will be taken as the
literal string "A1" rather than the contents of A1. The OP did have 6
numbers, so the range should include F1.

Hope this helps.

Pete

On Jul 31, 12:07*am, robzrob wrote:

Why isn't it =COUNTIF(B1:F1,"<A1") * ???

Reply With QuoteReply With Quote