Share via

Excel Formular

Anonymous
2021-08-27T14:18:19+00:00

My excel sheet shows bids for a project. The bid columns all total (AUTOSUM) at the bottom. I want to identify the lowest bid across the bottom row of bids. I tried MIN and SMALL but some of the columns are blank and total at the bottom to zero (0). I need the lowest number that is greater than zero.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-27T16:39:50+00:00

    Thank you, but this did not work. It was still returning 0 as the result.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-08-27T16:38:54+00:00

    YES!

    Thank you for the assistance. Much appreciated.

    Was this answer helpful?

    0 comments
  3. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2021-08-27T14:46:54+00:00

    Excel 2016 has got MINIFS function which you can use.

    =MINIFS(B2:R2,B2:R2,">"&0)

    Was this answer helpful?

    0 comments
  4. HansV 462.6K Reputation points
    2021-08-27T14:27:40+00:00

    Let's say the totals are in B25:K25

    In another cell, enter the following array formula, confirmed with Ctrl+Shift+Enter:

    =MIN(IF(B25:K25>0,B25:K25))

    Was this answer helpful?

    0 comments