combining formulas
 

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D11:D40))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you

combining formulas
 

Encompase the two equations like:

=MIN(MIN(),MIN())
--
Gary''s Student - gsnu200813


"Rene" wrote:

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D11:D40))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you

combining formulas
 

=MIN(MIN(J11:J40,"b",D11:D40),MIN('[abc.xlsx]2008 mine'!G313:G367))
{=MIN(MIN(if(J11:J40,"b",D11:D40),MIN('[abc.xlsx]2008 mine'!G313:G367)))}

both return a value error

"Gary''s Student" wrote:

Encompase the two equations like:

=MIN(MIN(),MIN())
--
Gary''s Student - gsnu200813


"Rene" wrote:

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D11:D40))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you

combining formulas
 

Your goal of using only one formula is good. However, cells are cheap.

Putting one min formula in, say Z1, and the other in Z2 and then using :
=MIN(Z1,Z2)

Only costs two extra cells and avoids the headache
--
Gary''s Student - gsnu200813


"Rene" wrote:

=MIN(MIN(J11:J40,"b",D11:D40),MIN('[abc.xlsx]2008 mine'!G313:G367))
{=MIN(MIN(if(J11:J40,"b",D11:D40),MIN('[abc.xlsx]2008 mine'!G313:G367)))}

both return a value error

"Gary''s Student" wrote:

Encompase the two equations like:

=MIN(MIN(),MIN())
--
Gary''s Student - gsnu200813


"Rene" wrote:

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D11:D40))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you

combining formulas
 

The MIN(IF is broken

=MIN(IF(J11:J40="b",D11:D40,"")) is the correct array part.
--
Gary''s Student - gsnu200813


"Rene" wrote:

=MIN(MIN(J11:J40,"b",D11:D40),MIN('[abc.xlsx]2008 mine'!G313:G367))
{=MIN(MIN(if(J11:J40,"b",D11:D40),MIN('[abc.xlsx]2008 mine'!G313:G367)))}

both return a value error

"Gary''s Student" wrote:

Encompase the two equations like:

=MIN(MIN(),MIN())
--
Gary''s Student - gsnu200813


"Rene" wrote:

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D11:D40))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you