Problem with the 0 value

G

Guest

Hello,

I need a formula to compare the list of entries in a column and display the
minimum of them at the end.

For example from D1:D50, each cell has 0 value in each cell based on a
formula (=A1+B1+C1), similarly for all the cells from D2 to D50.

Based on the entries in the columns A, B and C the total of them is getting
displayed in column D.

If the entries are 5 (range A1:C5), the sum is getting displayed from D1 to
D5 and the other cells D6 to D50 are showing as 0 because of the formula.

I am trying to put the formula =MIN(D1:D50) in D51 but the value is showing
as 0 instead of the lowest among the five values in D1 to D5.

How do I get the minimun value which looks only the entries and displays the
minimum ignoring the 0 values in the same column.

Thanks in advance
Sasikiran
 
G

Guest

an easy way is to put an interim step in column E

=if(d1>0,d1,"")

then calc the min on column E

hope this helps.
 
J

JW

Array formula. Enter with Ctrl+Shift+Enter.
This will ignore any values equal to or less than 0.
=MIN(IF(D1:D50>0,D1:D50))
 

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

Top