apart from the second one having a mistake in the range (which I assume is a
typo), they both work for me.

Are you sure that they are actually dates, not text? Try this which might
show it

=SUMPRODUCT((--(A1:A100)=DATE(2005,3,1))*(--(A1:A100)<=DATE(2005,3,31))*(UP
PER(B1:B100)="A"))

other than that post some data examples.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kwong" wrote in message
...
hello everyone,

Good day, my question:

I need to calculate the number of times an item appears within a date
range. Meaning, if column A is contains my dates ranging from 1/1/05 -
7/1/05
and column B contains various symbols (ie A, B, C etc.), I need to
calculate
how many A's appear between 3/1/05 - 3/31/05.

I had tried some solutions given:

=SUMPRODUCT((MONTH(A1:A100)=3)*(YEAR(A1:A100)=2005 )*(UPPER(B1:B100)="A"))

or


=SUMPRODUCT((A1:A100=DATE(2005,3,1))*(A1:A100<=DA TE(2005,3,31))*(UPPER(A1:A
100)="A"))

but unfortunately it doesn't work...
anyone can help me with this? Thank you for your time for reading my
post....