MIN ingnoring zero sum in an range of cells

G

Gulicio

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
 
G

Gulicio

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
Click to expand...


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:Z1>0,A1:Z1))
 
T

T. Valko

Based on your original example with multiple ranges:
=min(a1:a10,b1:b10)
Click to expand...

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

--
Biff
Microsoft Excel MVP


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
Click to expand...


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:Z1>0,A1:Z1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

min,average>0 if 52 cells read zero 2
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
getting the min and max of a list of numbers 9
Min in array formula 2
Code to format cells on several worksheets 2
=MIN() Function 4
macro for a range 0
Macro to hide rows with zero in specifc column range 2

Top