formula for minimum value not to include blank cells

[still learning]

Hi
When I use the formula

=min(T226:T550)

to find the lowest number in a row, It returns a false number because T270:T550 is blank. I will add numbers about every couple of weeks.
Is there a way to have the formula not include blank cells?


mike

 

[Alex Blakenburg]

Min ignores blanks and it even ignores text including empty strings ie "".
Do you have a formula in column T and can you show us what that formula is ?
Is you "blank" zero a formatted to show as blank by any chance ?

 

[still learning]

Hi Alex
after your reply, I went back and took a better look at the numbers and found the "false" number in the row. I thought all the numbers were above 600 and below 800.
the result was 455. that's why I thought i have a wrong result.

Thanks for your help

mike

 

[Alex Blakenburg]

You're welcome. Thanks for letting us know.