Results 1 to 9 of 9

Formulas Needed - MIN, AVERAGE, MAX

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    Syracuse, NY
    MS-Off Ver
    Excel 2010
    Posts
    23

    Question Formulas Needed - MIN, AVERAGE, MAX

    This seems like a simple task, but I cannot get any formulas to provide the appropriate results.

    I need formulas for MIN, AVERAGE, MAX.
    Need to ignore zero-values
    Need to ignore columns in between the subject-columns of "Cost".

    Array formulas do not appear to work, because there is other unrelated column data between the "Cost" columns that need to be calculated.

    See attached spreadsheet.
    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. Average and vlookup help needed
    By Des1801 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2014, 07:54 AM
  2. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  3. Replies: 10
    Last Post: 04-25-2013, 06:12 PM
  4. [SOLVED] Macro needed for Average/Sum formulas in 2 columns
    By denny2468 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2013, 03:29 PM
  5. Countif, then average needed
    By Cyants in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-26-2006, 12:23 AM

Tags for this Thread

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