Try this:

A1: =SUMPRODUCT(COUNTIF(E:E,{"DAR","DAC","DAO"}))

(Note the curly braces around the criteria array)

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=528093