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