I am trying to find out the correct way to write a formula in Excel. We are trying to first determine if something falls into a date range, such as between 6/1/2011 and 6/15/2011 in row D. If something does fall into that date range, then we want to add up the corresponding amounts from row E to be summed together for us. Just to give you the correct ranges, we are looking at the dates from D5:D700 and the number amounts from E5:E700. Can someone please help me out? Thanks so much!

re: " row D, row E"Just to avoid any confusion, D & E are

Columns, not rows.These formulas should get you what you are looking for.

Note that these formulas will

include6/1 and 6/15. If by"between 6/1/2011 and 6/15/2011"you mean that you don't want to include 6/1 and 6/15, drop the "equal signs" before both DATEVALUE functions.=SUMPRODUCT((D5:D700>=DATEVALUE("06/01/2011"))*

(D5:D700<=DATEVALUE("06/15/2011")),E5:E700)=SUMIF(D5:D700,">="&DATEVALUE("6/1/2011"),E5:E700) - SUMIF(D5:D700,">="&DATEVALUE("6/15/2011"),E5:E700)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you very much for your quick answer. I would like to make you the "KING of EXCEL".

Thanks DerbyDad03

Ask Your Question

Weekly Poll