HELP! with long function

[Guest]

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 D429
for those dates.

Can anyone help, please, please?

 

[Bernard Liengme]

=SUMPRODUCT(--(MONTH(A4:A29)=7), D429)
For more details on SUMPRODUCT
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Guest]

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

 

[Bernard Liengme]

Good point, I forgot to check year (data could be multi-years)
best wishes

 

[T. Valko]

Take your pick:

=SUMIF(A4:A29,">="&DATE(2007,7,1),D429)-SUMIF(A4:A29,">"&DATE(2007,7,31),D429)

A1 = 7/1/2007
B1 = 7/31/2007

=SUMIF(A4:A29,">="&A1,D429)-SUMIF(A4:A29,">"&B1,D429)

=SUMPRODUCT(--(TEXT(A4:A29,"m/yyyy")="7/2007"),D429)