Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average Founction HELP
Another way, if you want to exclude zero's... =AVERAGE(IF(A1:A100,A1:A10)) ...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=355567 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
AVERAGE problems | Excel Worksheet Functions | |||
Average (geometric) | Excel Worksheet Functions | |||
Average | Excel Worksheet Functions | |||
average, array and offsets | Excel Worksheet Functions |