Min value excluding 0 and another criteria

  • Thread starter Thread starter calebmichaud
  • Start date Start date
C

calebmichaud

Hi

I am trying to exclude zero plus add another criteria in calculating
the min value of a column. I want the other criteria to be the text
value of a different column. For instance column A has dog, cat,
fish, etc (up to 16 category types) and column B has age. I am trying
to find min age for each category and not include zero.

I know this will find the min age of everything
=MIN(IF($G$5:$G$40>0, $G$5:$G$40))

but i am at a lost for how to incoporate the other criteria

any suggestions would greatly be appreciated
 
Hi

I am trying to exclude zero plus add another criteria in calculating
the min value of a column.  I want the other criteria to be the text
value of a different column.  For instance column A has dog, cat,
fish, etc (up to 16 category types) and column B has age.  I am trying
to find min age for each category and not include zero.

I know this will find the min age of everything
=MIN(IF($G$5:$G$40>0, $G$5:$G$40))

but i am at a lost for how to incoporate the other criteria

any suggestions would greatly be appreciated
Click to expand...

Maybe...

=MIN(IF(($G$5:$G$40>0)*($A$5:$A$40="dog"), $G$5:$G$40))
for minimum of dog ages

entered as an array formula.

Ken Johnson
 
thats returning a zero.
here is what i am using...exchanging dog for a cell regerence

=MIN(IF(($G$5:$G$40>0)*($E$5:$E$40=E5), $G$5:$G$40))
 
ken

disregard my last posting. didnt see the line that says to enter as
an array. works great now....thanks!!!!
 
disregard last posting. didnt see the enter as array line. works
great. thanks a bunch!!!
 
Back
Top