What type of data is in B22?

On a lark, try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:6477812ddc2f2@uwe...
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