Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average Formula
Need a formula to average a range of cells but only if there are numbers so I dont get a zero. =AVERAGE(IF(E8:N8,E8:N8)) this is what I'v tried but I just get #VALUE! Thanx -- ferg ------------------------------------------------------------------------ ferg's Profile: http://www.excelforum.com/member.php...o&userid=36519 View this thread: http://www.excelforum.com/showthread...hreadid=563563 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Average formula | Excel Discussion (Misc queries) | |||
Formula to average certain times | Excel Discussion (Misc queries) | |||
Average Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |