=SUMPRODUCT(--(MONTH(A4:A29)=7),--(YEAR(A4:A29)=2007),D4:D29)


"spoe" wrote:

I need to write a function with the following parameters for a work
spreadsheet.

If A:4:A29 is between the dates 07/01/2007 and 07/31/2007, add cells D4:D29
for those dates.

Can anyone help, please, please?

--
Spoe