Calculate MIN excluding zero

G

gezuvor

I am trying to calculate the MIN of several non-consecutive columns, but
want the calculation to ignore columns that have no value or zero (0) in
them.

The columns being queried have calculations of their own in them, but
hopefully that isn't part of the problem.

Anyway, the calculation I am using is =MIN(G291,I291,K291,M291), which
will return a zero/null value if one of the cells is empty. I did a
search and MSFT tells me I should use =MIN(A1:A10>0,A1:A10), which
doesn't work for me.

Suggestions?
 
P

Peo Sjoblom

=MIN(IF((MOD(COLUMN(G291:M291),2)=1)*(G291:M291<>0),G291:M291))

entered with ctrl + shift & enter

and it will only check every other cell, if the formula from the link works
then this will work as well

=MIN(IF(G291:M291<>0,G291:M291))

also entered with ctrl + shift & enter, if you only want values greater than
zero change
<> to >



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon
 

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

ignore MAX and MIN values in a set to calculate average 5
getting the min and max of a list of numbers 9
=MIN() Function 4
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
Min Excluding Value 8
Min excluding zero values, without an array fomrula 13
Min Function Excluding Zero Values & More 8
How calculate a MIN excluding the 0 values 5

Top