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

How do you handle this? In column AH: Y, N and U and blanks. I want to count
all the U's and N's.



Don Guillett wrote:
sure

That Works GREAT!

[quoted text clipped - 10 lines]

Sharon

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1