Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional average function | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
Conditional Average Ignoring Blanks | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |