Thread
:
IF Statement
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
IF Statement
try
=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B22),--(Odyssey!$AH$2:$AH$999={"U","N"}))
--
Don Guillett
SalesAid Software
"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:6476fd428bda4@uwe...
=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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett