I have been trying to make a averageif formula that is based on a criteria but haven't been successful.
I'm having trouble sharing the attachment of the sheet.
What I am trying to do is calculate the average between two columns based on a criteria. I am trying to find in all row that meet the criteria in sheet 2 (someone will enter the start date, end date and specific model family. So when someone put "august 6, 2021" to "august 21, 2021".. model - "steamers"... It will pull from sheet 1 .. column E the steamers and all the order date and completion date between the date range provided and calculate the average day in production that will be reflected in sheet 2 under average.
Bookmarks