=SUMPRODUCT(--(MONTH(Sheet1!A1:A100)=1),Sheet1!B1:B100)

--

HTH

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


"FBS" wrote in message
...
I have two columns in excel that gets its data from an access database.
The
two columns are Calendar dates and the other numbers, I would like to have
a
formula in a second worksheet that looks up a range of dates i.e.; March
Sales and displays a sum of the corresponding figures in the second
column.--
do it right, do it once