MIN ingnoring zero sum in an range of cells
 

I have a spread sheet where I need to use =min(a1:a10,b1:b10) but
ignoring any cells with a zero in the range. Please hel. I have been
searching the groups for hours. Tks in advance

MIN ingnoring zero sum in an range of cells
 

On Dec 22, 3:18*pm, Gulicio wrote:
I have a spread sheet where I need to use =min(a1:a10,b1:b10) but
ignoring any cells with a zero in the range. Please hel. I have been
searching the groups for hours. Tks in advance


Finally found answer that worked for thoose still looking here it is:

try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:Z10,A1:Z1))

MIN ingnoring zero sum in an range of cells
 

Based on your original example with multiple ranges:

=min(a1:a10,b1:b10)

=SMALL(A1:B10,COUNTIF(A1:B10,0)+1)

--
Biff
Microsoft Excel MVP


"Gulicio" wrote in message
...
On Dec 22, 3:18 pm, Gulicio wrote:
I have a spread sheet where I need to use =min(a1:a10,b1:b10) but
ignoring any cells with a zero in the range. Please hel. I have been
searching the groups for hours. Tks in advance


Finally found answer that worked for thoose still looking here it is:

try the following array formula (entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:Z10,A1:Z1))