IF Statement

[s2m via OfficeKB.com]

Basically all I want to do is count the number of dates that ="Y" in columns
AH, for the month of August 06. The date field is in column AI.


=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B7),--(Odyssey!$AH$2:$AH$999="Y"),--
(Odyssey!$AI$2:$AI$999>=8/1/6),--(Odyssey!$AI$2:$AI$999<=8/31/6))

Thanks

Sharon

 

[Don Guillett]

try this if your dates ARE dates
=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B7),--(Odyssey!$AH$2:$AH$999="Y"),--
(month(Odyssey!$AI$2:$AI$999)=8))

 

[s2m via OfficeKB.com]

That Works GREAT!

Can I keep building on a SUMPRODUCT? Adding more conditions? Like AZ= N,
AM= Y and so on?

try this if your dates ARE dates
=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B7),--(Odyssey!$AH$2:$AH$999="Y"),--
(month(Odyssey!$AI$2:$AI$999)=8))

Basically all I want to do is count the number of dates that ="Y" in
columns

[quoted text clipped - 6 lines]

Sharon

 

[Guest]

YES!

That Works GREAT!

Can I keep building on a SUMPRODUCT? Adding more conditions? Like AZ= N,
AM= Y and so on?

try this if your dates ARE dates
=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B7),--(Odyssey!$AH$2:$AH$999="Y"),--
(month(Odyssey!$AI$2:$AI$999)=8))

Basically all I want to do is count the number of dates that ="Y" in
columns

[quoted text clipped - 6 lines]

Sharon

 

[Don Guillett]

sure

--
Don Guillett
SalesAid Software
(e-mail address removed)

That Works GREAT!

Can I keep building on a SUMPRODUCT? Adding more conditions? Like AZ= N,
AM= Y and so on?

try this if your dates ARE dates
=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B7),--(Odyssey!$AH$2:$AH$999="Y"),--
(month(Odyssey!$AI$2:$AI$999)=8))

Basically all I want to do is count the number of dates that ="Y" in
columns

[quoted text clipped - 6 lines]

Sharon

 

[s2m via OfficeKB.com]

=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.

sure

That Works GREAT!

[quoted text clipped - 10 lines]

 

[Don Guillett]

try

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

--
Don Guillett
SalesAid Software
(e-mail address removed)

=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.

sure

That Works GREAT!

[quoted text clipped - 10 lines]

Sharon

 

[s2m via OfficeKB.com]

I get a #VALUE! error message

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]

 

[RagDyer]

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 !
---------------------------------------------------------------------------

I get a #VALUE! error message

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