Forum Discussion
Solved
I need help with a formula
I am working on a Monthly Cycle Time Report for vehicles I have in service. I need a formula to show how many are completed once I input the RO close time. EXAMPLE: STOCK RO DATE OPEN ...
Few variants. You may create PivotTable. You may use dynamic arrays formulas if your version of Excel supports it. You may use COUNIFS on per-cell basis if you have pre-defined list of types.
Formulas are in attached file.
I think I will create a pivot table to help stay organized . I will try these formulas out. Thank you SergeiBaklan
CrimsonTrail , you are welcome