Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Dear all,
I have a series of data in Column A A 2 5 6 =average(a1:a9) 7 Cell A4 is the average from A1 to A5, in this case is 5 However, if I simply put this formula into A4, it obviously is an error. What should be the formula then? Thanks Kent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I open an excel file if I am getting a cyclic error? | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
How do I correct a cyclic redundancy check error | Excel Discussion (Misc queries) | |||
How do I correct a cyclic redundancy check error | Excel Discussion (Misc queries) | |||
data error - cyclic redundancy check | Excel Discussion (Misc queries) |