Conditional Average
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 |
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 |
Almost there
=AVERAGE(IF(N$2:AR$2<TODAY(),N194:AR194)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom (No private emails please) "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 |
Excellent. Cheers Biff, works a treat. 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 |
How do I start a new thread? I am a newbie here. tx -- Clearwater14 ------------------------------------------------------------------------ Clearwater14's Profile: http://www.excelforum.com/member.php...o&userid=26496 View this thread: http://www.excelforum.com/showthread...hreadid=397630 |
All times are GMT +1. The time now is 05:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com