Count function

[Guest]

I'm trying to count a column with some kind of criteria.
Count if cell contains EL or HC or MM etc.

Can it be done with the countif functions?

Appreciate any help.

 

[Don Guillett]

try

=SUMPRODUCT((H1:H21={"el","he","mm"})*1)

 

[Jason Morin]

=SUMPRODUCT(--(A1:A1000={"EL","HC","MM"}))

HTH
Jason
Atlanta, GA