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:A100)="A"))

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