Thread: Count if not a number
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default Count if not a number
"Peo Sjoblom" wrote...
Or the more generic

=COUNT(AI7:AT7)=COLUMNS(AI7:AT7)
....

More generic still,

=COUNT(rng)=COLUMNS(rng)*ROWS(rng)

=COUNTIF(rng,"=")+COUNTIF(rng,"*")=0

=AND(ISNUMBER(rng)) [array formula]

Reply With QuoteReply With Quote