| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect IF statement AND allow data entry | Excel Worksheet Functions | |||
| SQL concatenation statement | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
