Thread: count specific text that occurs in a range of cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default count specific text that occurs in a range of cells

Hi Tim,

=SUMPRODUCT(--(A1:A10="NUMBER"),--(OFFSET(A1:A10,1,0)="TEXT"))

is probably a more logically consistent form of the same equation.

Ken Johnson

Reply With QuoteReply With Quote