Go to a cell based on a number in another page.

I am making a excel sheet to record data for a tournament I'm going to. I need to have separate averages for both day 1 and day 2. Each competition takes 6 rows in excel, so a wrote a short formula to take the last match of day one and find which row that is. I want to find the average of that column (say C) from the first entry (row 2) to the row of the last match. So if the last match of day 1 is the 6th one (which corresponds to the row 32) I want to find the average from C2:C32. How would I go about doing this, preferably without VBA because I don't know that much about it?
Thank you.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work on this forum, so don't try to use that.

Hope this helps.

Pete

This is a copy of my main file. The cell E10 on the customization page is where I input the last match of day 1. Cells F10 and G10
calculate the last row of day 1 and the first row of day 2. On the template page in cells O5-AF5 I find the average of day 1. The data is in colums
B through K. Example: I want to find the average amount of times a team crossed the line in day one, and display it in cell O5 using the last row of
day 1 info from cell F10 on the customization page. If F10 said 32 I want to go find the average for day one using cells C2:C32.

@ben_hensel
Thank you. Also I don't understand much excel so is this how it works? the first argument defines the range of cells to find the average (Which would be change to the template page not data entry), and if the row is less than the value in F10 on the customization page find the average of the cross line column?
The button on the customization page when pressed creates a page for each team with their own data and averages based off the template page. Data Entry will have the information for all the teams.
Also is there equivalent function for Median, like MEDIANIF? and would it be set up the same way?