I am trying to pull together a spreadsheet that will allow me to average a "total" column using dates.

A2: TO A500 are cells that hold dates " 01/03/2012 etc

H2: TO H500 are cells that hold totals ie 15, 56, 27 etc

K2 is called "First Week"

L2 is called "Second Week"

these two cells have drop downs that allow me to choose dates that correspond to the dates in cells A2 - A5

M2 is called Average - this is the cell that i need the formula in. I would like it to calculate the average of two dates selected in K2 and L2, from the totals from H2 TO H500. The problem i have is i want it to only use certain cell numbers in the H column ie H2,H6,H9,H12 etc.

Can this be done?

I know this is long winded by i try my best.

Thank you in advance.

Red