orbea_adam
Well-known Member
- Joined
- Nov 15, 2005
- Messages
- 500
I have the following formula confirmed with ctrl+shft+entr:
{=COUNT(IF(AND(MONTH(M4:M30)=MONTH(A39&C33),YEAR(M4:M30)=C33),,))}
m4:m30=list of dates
a39="June"
c33=2008
The formula results in 1, which is the count of false occurrences. What am I doing wrong causing count of false instead of true. The answer should be 6.
Adam
{=COUNT(IF(AND(MONTH(M4:M30)=MONTH(A39&C33),YEAR(M4:M30)=C33),,))}
m4:m30=list of dates
a39="June"
c33=2008
The formula results in 1, which is the count of false occurrences. What am I doing wrong causing count of false instead of true. The answer should be 6.
Adam