Forum Discussion
Solved
SUMIF Function for a period between two dates
Hi all,
I'm in a bit over my head with this at the moment..
I'm trying to keep track of pallet storage costs. To this end I would like to have cell D2 = sum of the cells in column C (2nd image below = seperate sheet) but only where column A = dates between 11/11/17 and 17/11/17 inclusive. I apologise if I haven't worded that very well.
Hopefully someone can lend their expertise... Thank you!
If so, then you have to use the second example which is based on the cell references, then fill down the target weeks and copy the formula down to calculate these weeks.
This shown in the attached file.
8 Replies
Erran,
I have attached the solution for you.
Hope that helps.
Thank you Haytham for your reply.
This solution does work, however it only works for the current week.
Without me editing the formula for each week in the Pallets In column, is there a way for me to auto-populate the required info?
If so, then you have to use the second example which is based on the cell references, then fill down the target weeks and copy the formula down to calculate these weeks.
This shown in the attached file.
