Min value excluding 0 and another criteria

[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

 

[Ken Johnson]

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

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

 

[calebmichaud]

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))

 

[calebmichaud]

ken

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

 

[calebmichaud]

disregard last posting. didnt see the enter as array line. works
great. thanks a bunch!!!

 

[Ken Johnson]

disregard last posting.  didnt see the enter as array line.  works
great.  thanks a bunch!!!

You're welcome.
Thanks for feeding back.

Ken Johnson