This is an estimate bid tabulation worksheet. NEI is my company. If I want to write a formula in cell G21 that calculates if cells J21:S21 all are NO BID then list cell I21 but if J21:S21 has a min number then carry the min number.Estimate Tab.xlsx