ooops, sorry
I meant to put this answer in a different thread


On 11 Gru, 18:21, Jarek Kujawa wrote:
I understood tha the OP only looks for the minimum non-empty cells
if there are empty cells the minimum would '0', or it wouldn't?

On 11 Gru, 14:23, Ron Rosenfeld wrote:



On Thu, 11 Dec 2008 04:43:16 -0800 (PST), Jarek Kujawa
wrote:

one way:

=SUM(IF(ISEMPTY(A1:A100),0,A1:A100))

this is an array-formula so CTRL+SHIFT+ENTER it instead of simply
using ENTER

How would the result of this differ from the normally entered:

* * * * =sum(a1:a100)

???
--ron- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -