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
|