Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
=This is a great forum - I've had several tough questions (for me anyway)
answered. I have yet another one. In two adjacent columns, I have data which will be divided against each other to get an average. The average is reported in a 3rd column, which is formatted as a percentage. The function in each row is similar - =B2/C2; =B3/C3, etc. At the bottom of the 3rd column, I want to calculate a MIN, MAX, and AVERAGE of all viable data points. Since empty rows come up as #DIV/0 (can't divide by zero, I suppose), the only values I'm getting are #DIV/0. What kind of functions do I need and where in order to skirt this problem? Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
average, array and offsets | Excel Worksheet Functions |