Wow, thanks all, all of your examples provided worked perfectly.

All of your responses are greatly appreciated...

Argus


On Thu, 20 Oct 2005 02:20:16 GMT, Odawg
wrote:

Hello all Excel Guru's:

This is a follow-up post that I made about a week ago. I had gotten
several responses to my question of MAX and MIN.

My question was, using the table below and using the following
formula:
=MIN(C1:C10) located in Cell C11, the answer should be 100
=MAX(C1:C10) located in Cell C12, the answer is 450

In column C, I have the following formulas:
=sum(A1+B1) and this is copied down to C10

A B C
1 100 100 200
2 150 200 350
3 200 250 450
4 50 150 200
5 50 50 100
6 125 275 400
7 100 125 225
8
9
10
11 The Min =
12 The Max = 450

The issue that I am having is with the MIN. Since there is no data in
C8:C10 because A8:B10 is empty, the MIN shows up zero (0), nothing in
C11 for MIN. but if I change the range from C1:C10 to a new range of
C1:C7, I get the correct answer of 100. Everyone stated that MIN
ignores blank cells, but C8:C10 is not really empty or blank, there is
a formula in each of thoses cells.

so my question becomes I do i get a MIN for range C1:C10.
Any and all help in this matter is greatly appreciated.