| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum to recognize new rows
I have a column that I average the sum (ignoring blank cells in the formula)
sum of column, divided by count of cells that are not blank. here is the formula that is in B10... =(SUM(B4:B9))/COUNTA(B4:B9) When I insert a row above B10 the formula does not change to incorporate that additional row. How can I get the formula to recognize new rows? should now be =(SUM(B4:B10))/COUNTA(B4:B10) Thanks -- deb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need formula that recognize | Excel Discussion (Misc queries) | |||
| Pivot Table Wizard Fails to Recognize New Rows of a Named Range | Excel Worksheet Functions | |||
| Pivot Table Wizard Fails to Recognize New Rows of Database | Excel Discussion (Misc queries) | |||
| Recognize #div/0! | Excel Discussion (Misc queries) | |||
| recognize the cell | Excel Discussion (Misc queries) | |||
Threaded Mode
