Thread: Countif query
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Countif query

=COUNTIF(AB2:AB26,"<"&0)
--
Max
Singapore
---
"Keith" wrote:
Take 2 - I don't think my first request got sent.

I am attempting to count the number of cells in AB2:AB26 that have a number
less thn zero. I have attempted this formula without success:

=COUNTIF(AB2:AB26,<0)