Conditional Average

K

Kstalker

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
 
B

Biff

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
 
P

Peo Sjoblom

Almost there

=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194))

entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom

(No private emails please)
 
Top