Solved Correct Formula for Date Range for Excel

June 22, 2011 at 16:34:50
Specs: Windows XP
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!

See More: Correct Formula for Date Range for Excel

June 22, 2011 at 16:51:44
✔ Best Answer
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 include 6/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.


=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.

Report •

June 23, 2011 at 07:48:44
Thank you very much for your quick answer.

I would like to make you the "KING of EXCEL".

Thanks DerbyDad03

Report •
Related Solutions

Ask Question