counting the number of dates

G

GORDON

I was using the tip counting the number of times dates in certain month
appears. I also needed it to count the number of "E"'s for that
month. the array that I used was:
=sum((month(a2:a11)=b2)*(year(a2:a11)=c2*1) column d would have some
blanks and some E'S. Would it be better off to use if,and,or
statements than the array or would I just and the if statements at the
end of the array?
 
A

Aladin Akyurek

=SUM((MONTH(A2:A11)=B2)*(YEAR(A2:A11)=C2)*ISNUMBER(A2:A11))

to be confirmed with control+shift+enter instead of just with enter.

=SUMPRODUCT(--(MONTH(A2:A11)=B2),--(YEAR(A2:A11)=C2),--ISNUMBER(A2:A11))

does not require control+shift+enter.
 
G

GORDON

Another issue I was having was to count the number of dates that wa
less than or equal to todays date and must have the letter E in anothe
column.

That is coulmn A would have the date 2003-10-21 column B would have th
letter E and column C would have the formul
=countif(A:A<="today")*(b:b,="E")

This seems logical but still lacks something for it to be correct.

I would appreciate any help anyone can give me with my two problems.
Thank
 
Top