where f1 is the start date and f2 the last date
=sumproduct((a2:a200=f1)*(a2:a200<f2)*d2:d200)

--
Don Guillett
SalesAid Software

"Dave" wrote in message
oups.com...
Hello All,
I have a worksheet with 4 columns of data. Column A is Dates (i.e.
07/26/2006...), Columns B and C fluff and Column D has $ amounts. I
have been asked to show the total $ amounts by month and Quarter in a
separate sheet. I'm looking for a way to do this with a formula but I
am not opposed to do it with VB.

Any help would be greatly appreciated.
David