I get a #VALUE! error message

Don Guillett wrote:
try

=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B22),--(Odyssey!$AH$2:$AH$999={"U","N"}))

=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B22),--(Odyssey!$AH$2:$AH$999="U"),--
(Odyssey!$AH$2:$AH$999="N"))
[quoted text clipped - 10 lines]

Sharon

--
Message posted via http://www.officekb.com