I have a report that is generated from an online portal and gives us details of aged orders that may exists in the system. We monitor any aged orders purely by the number of them still active s a performance indicator
Ive been trying to use the dates in the Order Date column (Column L) against a formula in cell Q5, that basically returns the number of orders equal to and older than the date in cell R3
Ive tried using =SUMPRODUCT(L:L<R3) as well as COUNTIF both of which either return a 0 or incorrect result
WOuld you have any suggestions as to return the correct figure? For the example Ive attached the correct redult should be 19 as they are all older or equal to 3rd December (in R3)
=COUNTIF(L:L, "<="&R3)