Thread: COUNTIF
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default COUNTIF
Gary''s Student wrote:
=COUNTIF(A1:A25,"Red")
=COUNTIF(A1:A25,"Blue")

Or simply =COUNTIF(A1:A25,{"Red","Blue"}) array entered into a
two-column row.

Alan Beban
Reply With QuoteReply With Quote