I’m trying to create a spreadsheet that captures historical monthly stats.
Column A contains the name of the item.
In column F I have the date an item has been received by myself.
In column K I have the date an item is then forwarded on.
In cell D4 I have a date (first day of a month)
In cell D5 I have a date (last day of a month)
The spreadsheet is a work in progress. Items may get forwarded the same month or several months later.
I will never use more than 5000 rows. I start recording items from row 13 onwards. Each entry remains in the row it is originally entered in.
I want a formula to return a sum of the number of outstanding items at the end of a particular month waiting to be forwarded on as follows:
If there is no date in column K (i.e. the item has been received by myself but has not been forwarded on), or if the forwarding date in column K is not between or equal to the dates in cells D4 & D5 I want to sum the number of items outstanding at the end of the month for that particular month.
This figure should then never change as the year progresses.