Formulating Data

Morning all, i had some help with my worksheet yesterday and have decided to recreate the workbook to make it easier to manage. i would like some help on this as i want to be able to locate the data in certain cells.

workbookhelp.xlsx

What i am trying to achieve is as follows;

Contract Sheet: Average:I Column, latest average to appear in I24.

I have formulated all the rows below the latest so they all automatically update but i want to calculate the totals at the bottom.

You have the drop downs calculating the total for you? I think I am misunderstanding the question.

You have the drop downs calculating the total for you? I think I am misunderstanding the question.

Sorry. Internet dropped out. Duplicate posts.

Hi
If date is sorted then use in I24

Formula:

Please Login or Register  to view this content.

otherwise use

Formula:

Please Login or Register  to view this content.

Jose, your an absolute Legend! that worked perfectly.