You're very close:
Array entered:
=AVERAGE(IF(N$2:AR$2,<TODAY(),N194:AR194))
Are you sure you want to EXCLUDE today's date?
To INCLUDE today's date:
=AVERAGE(IF(N$2:AR$2,<=TODAY(),N194:AR194))
Biff
"Kstalker" wrote in
message ...
Hello again.
Yet another problem in my world of elaborate worksheets.
I need to calculate the MTD average based on todays date.
Have mdae several attempts but clearly do not quite have the skill.
=AVERAGE(IF(N$2:AR$2,"<" & TODAY(),N194:AR194))
Regards
Kristan
--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile:
http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=397630