Thread: COUNTIF
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default COUNTIF

That didn't work for me.

I bet you meant:
=SUM(COUNTIF(A1:A25,{"Red","Blue"}))
(not an array formula)

Alan Beban wrote:

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


--

Dave Peterson