Results 1 to 8 of 8

minimum sum value excluding value 0

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    minimum sum value excluding value 0

    Good evening,
    as the title suggests, I need to find in a sum,
    the minimum value other than 0.
    In the attached file in column M I report the minimum values of the sums of various columns.
    in cell M2 it gives me the minimum value which is 0
    but, excluding 0, it should be 45.58

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Return minimum value excluding zero - Non array help
    By MXSYYC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2019, 01:28 PM
  2. Finding Minimum Excluding the zero
    By thong127 in forum Excel General
    Replies: 18
    Last Post: 10-21-2016, 01:31 PM
  3. [SOLVED] Better way to find minimum value excluding zero and non number
    By a_driga in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-07-2014, 07:26 AM
  4. [SOLVED] Finding the minimum value in a range but excluding one value
    By Wilgoss in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-04-2012, 08:39 AM
  5. Averaging values, excluding minimum value
    By LoriR in forum Excel General
    Replies: 10
    Last Post: 04-22-2011, 03:45 AM
  6. Minimum value excluding zero?
    By Ritte in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 12-30-2009, 05:18 PM
  7. Find Minimum, excluding ties
    By Georgia Golfer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2009, 12:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1