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 imag...
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.
Oh thank you so much. I apologise for not looking closely enough.
Much appreciated 😁
Much appreciated 😁
I try to make easier for you Erran Williams by modifying data from Haytham Amairah (sorry). I transform ranges to table then change table's name to be "base". the see the formula very easy to be understood.
Thank you sandi saputra,
And thank you Haytham Amairah
My workbook is now functioning nicely. I'll post again next time something is a bit beyond me (prob won't be too far away)