That worked. Just had to add the ' around period data and the good 'ole
CTRL+Shift+Enter.

Thanks mate!

"SteveG" wrote:

>
> Make sure you are entering your formula in as an array.
>
> =AVERAGE(IF(Period Data!A1:A200="January",IF(Period
> Data!E1:E200=2005,Period Data!F1:F200,FALSE)))
>
> When you complete the formula, don't hit enter to commit, hit
> Ctrl-Shift-Enter Simultaneously. This will create curly brackets
> around the formula.
>
> {=AVERAGE(IF(Period Data!A1:A200="January",IF(Period
> Data!E1:E200=2005,Period Data!F1:F200,FALSE)))}
>
> HTH
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=502639
>
>