Hi Kevin,

To pull the average of all days for a specific account from the RawData sheet to the Analysis sheet, you can use the AVERAGE, INDEX, and MATCH functions together.

Here are the steps:

1. In the Analysis sheet, enter the account number you want to reference in a cell. Let's say you enter it in cell B1.
2. In the cell where you want to display the average, enter the following formula:
   
   
   Formula:

   =AVERAGE(INDEX(RawData!$A:$D, MATCH(B1, RawData!$B:$B, 0), 2):INDEX(RawData!$A:$D, MATCH(B1, RawData!$B:$B, 0), 4)) 

   Let's break down this formula:
   
   - INDEX(RawData!$A:$D, MATCH(B1, RawData!$B:$B, 0), 2) returns the cell in the RawData sheet that corresponds to the row where the account number is found (using the MATCH function) and the second column (where the balances for Day 1 are located).
   - INDEX(RawData!$A:$D, MATCH(B1, RawData!$B:$B, 0), 4) returns the cell in the RawData sheet that corresponds to the row where the account number is found (using the MATCH function) and the fourth column (where the balances for Day 3 are located).
   - The colon between the two INDEX functions creates a range of cells that includes all the balances for the specified account.
   - AVERAGE calculates the average of all the balances in the range.
   
3. Press Enter to calculate the average.

This formula will dynamically update if the account number moves to a different column or if new data is added to the RawData sheet.