Hi All,
I have a number of columns of data. The data is organised into whether a vehicle is "on" or "off" fleet, its location and whether the vehicle is manual or automatic. The formula is as below;
=COUNTIFS(A11:A998,"On Fleet",B11:B998,"A & J",H11:H998,"Auto")
I am looking for a formula which will allow me to further analyse another column which has a contract end date. What I need to do is to understand how many of the vehicles counted as per the above formula fall within a 90 day window.
Is this possible? For reference the date range is in column I.
Any help appreciated.
Thank you
Bookmarks