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
Bookmarks