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
|