|
IF Statement
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200608/1 |
IF Statement
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)) -- Don Guillett SalesAid Software "s2m via OfficeKB.com" <u23063@uwe wrote in message news:6476766e5d591@uwe... 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200608/1 |
IF Statement
That Works GREAT!
Can I keep building on a SUMPRODUCT? Adding more conditions? Like AZ= N, AM= Y and so on? Don Guillett wrote: 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 -- Message posted via http://www.officekb.com |
IF Statement
YES!
"s2m via OfficeKB.com" wrote: That Works GREAT! Can I keep building on a SUMPRODUCT? Adding more conditions? Like AZ= N, AM= Y and so on? Don Guillett wrote: 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 -- Message posted via http://www.officekb.com |
IF Statement
=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 |
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 |
IF Statement
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 |
IF Statement
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 |
| All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com