| 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 |
| 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) | |||
Threaded Mode
