Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with AVERAGE function
Hi all,
Let's say I want to calculate the average of these numbers: 40, <14, 20, <14, 60 I want the average to show <29.6 but when I do the average function =average(a1:a5) excel ignores the two <14 and gives the average of 40. Can anyone help please? I'm faced with this problem almost daily and forced to do manual calculations. Thanks in advance, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring daily average...function ??? | Excel Worksheet Functions | |||
AVERAGE function returns #DIV/0! error | Excel Discussion (Misc queries) | |||
Average function assistance | Excel Discussion (Misc queries) | |||
EXCEL 2000 AVERAGE function | Excel Worksheet Functions | |||
Using the average function | Excel Worksheet Functions |