Sorry - misprint. The formulae should read as follows:

=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(B1:B100)="A"))KL"KL" wrote in .. . Hi Diane1477, Try something like this: =SUMPRODUCT((MONTH(A1:A100)=3)*(YEAR(A1:A100)=2005 )*(UPPER(A1:A100)="A")) or=SUMPRODUCT((A1:A100=DATE(2005,3,1))*(A1:A100 <=DATE(2005,3,31))*(UPPER(A1:A100)="A")) Regards, KL "Diane1477" wrote in ...I need to calculate the number of times an item appears within a daterange. Another words, 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 tocalculate how many A's appear between 3/1/05 - 3/31/05. Is ther a formula to use?Or is there a way to do a combination IF/THEN statement? (If Column A isbtwn 3/1/05-3/31/05 then count "A" that appear in column B) I am using Excel2000. PLEASE HELP. My brain is goingo n overload!