|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Trying to get an IF/AND average to work
Care for a virtual beer? Cheers!
"SteveG" wrote:
This should do it for you.
=AVERAGE(IF(Period Data!A1:A200="January",IF(Period
Data!E1:E200=2005,IF(Period Data!F1:F200<"",Period
Data!F1:F200,FALSE))))
Again, it is an array formula.
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
|