finding average with date dependant and cell dependant

[sfoll]

hi guys

I have a table full of data ( football )
in cell aa1 I want to return the average of column L but only if cell z1 is found in column C and if the date lays between 05/08/11 and 13/05/12 which is in column B

is this possible please

Thanks in advance

[Richard Buttrey]

Hi,

Check out the =AVERAGEIFS() function

[Pete_UK]

Try this:

=AVERAGEIFS(L:L,C:C,$Z$1,B:B,">="&"05/08/2011",B:B,"<"&"13/05/2012")

I've shown the dates appended to the comparison, as I imagine you would have those in separate cells, so you just replace the date with the cell reference.

Hope this helps.

Pete

[sfoll]

brilliant.

Thank you Pete

[Pete_UK]

You're welcome - thanks for the rep.

Pete