I have a column of months (date item submitted) and am using the below to count the number within the month
=SUMPRODUCT(--($J$2:$J$847=N5))
In column K there are months (date item received) I would like to count the number received in the month of those submitted. so column j is submitted and shows month number, column K is received
problem is column K may have items received in the month, but were submitted in a previous month, I dont want to count these.
Any ideas what formula can be used?
=SUMPRODUCT(--($J$2:$J$847=N5))
In column K there are months (date item received) I would like to count the number received in the month of those submitted. so column j is submitted and shows month number, column K is received
problem is column K may have items received in the month, but were submitted in a previous month, I dont want to count these.
Any ideas what formula can be used?