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

I'd apply data|filter|autofilter

Then filter to show Jan 2005 and Trues.

I bet you have 2.

GregR wrote:

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

--

Dave Peterson

ps watch out for hidden rows!

GregR wrote:

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

--

Dave Peterson

Dave, thanks. I figured it out. Had a problem with my True/False Col ,
which was hidden. When I fixed it, the problem went away. Your
suggestion of "hidden rows" pointed me in the right direction.

Greg