Hi driller3_banter,

It looks like you're trying to summarize data from Sheet 1 based on certain criteria. Here's a step-by-step guide on how to do this using Microsoft Excel:

1. Create a new sheet where you want to display the summary results.
2. In cell A1 of the new sheet, enter the heading "Input Criteria".
3. In cell B1, enter the formula "
   Code:

   =formula

   ".
4. In cell A2, enter the heading "Summary Result".
5. In cell B2, enter the formula "
   Code:

   =IFERROR(INDEX(Sheet1!$A$1:$A$12,SMALL(IF(Sheet1!$B$1:$B$12=$B$1,ROW(Sheet1!$A$1:$A$12)-ROW(Sheet1!$A$1)+1),ROW(1:1))), "")

   ".
6. Press Ctrl + Shift + Enter to enter the formula as an array formula.
7. Copy the formula in cell B2 and paste it down to the rest of the cells in column B where you want to display the summary results.
8. The summary results should now be displayed in column B based on the input criteria in cell B1.

I hope this helps! Let me know if you have any questions.