Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct to count
I have the following formula:
=SUMPRODUCT(--($C$6:$C$2000=C$1),--(YEAR($B$6:$B$2000)=2005),--(AE$6:$AE$2000=TRUE)) where I am trying to count the number of items in Col AE that are true, the month in Col C =C1 or Jan in the year 2005 Col B. The expected result is 0,but the returned value is 2, the correct count for 2006. Help! TIA Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMProduct / Count | Excel Discussion (Misc queries) | |||
SUMPRODUCT, count & sum | Excel Worksheet Functions | |||
Count without SUMPRODUCT | Excel Worksheet Functions | |||
Count if and Sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct to count | Excel Programming |