LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Allen7575
 
Posts: n/a
Default MIN, MAX, AVERAGE functions

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average the Last Five Cells in a Column Warrior Princess Excel Worksheet Functions 3 March 16th 05 02:12 PM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 09:57 AM
# of Functions per cell SUB-ZERO Excel Worksheet Functions 3 January 23rd 05 10:35 PM
PivotTable canned functions doco Excel Discussion (Misc queries) 0 January 14th 05 03:52 PM
average, array and offsets Darin1979 Excel Worksheet Functions 0 November 17th 04 04:21 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"