=SUMPRODUCT(--(MONTH(A4:A29)=7), D4:D29)
For more details on SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"spoe" wrote in message
...
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