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.
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
