I want to use a IF formula to pick up the number in a cell, only if the dates in which it rates to fall between two dates. Eg if the start date is between the two dates, then pick up a number from the cell.
When there are two lists in your worksheet as right screenshot shown, one is the list of dates, the other is the list of the values. And you want to sum up the values between two dates range only, for instance, sum up the values between 3/4/2014 and 5/10/2014, how can you calculate them quickly? Now, I introduce a formula for you to sum up them in Excel.
Fortunately, there is a formula can sum up the values between two dates range in Excel.
Select a blank cell and type into this formula =SUMIFS(B2:B8,A2:A8,">="&E2,A2:A8,"<="&E3), and press Enter button. And now you will get the calculating result. See screenshot:
Note: In above formula, B2:B8 is the value list you will sum up, A2:A8 is the date list you will sum based on, E2 is the cell with start date, E3 is the cell with end date, and you can change them based on your needs.
|Formula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future!
Read more… Free trial
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
200 New Features for Excel, Make Excel Much Easy and Powerful: