Results 1 to 14 of 14

How to AVERAGEIF not using a range of cells?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-12-2020
    Location
    USA
    MS-Off Ver
    2013
    Posts
    133

    How to AVERAGEIF not using a range of cells?

    I've got a formula that will pull in a number. Sometimes that number will be 0. I want to get the average of the items not counting any zeroes. I want this =AVERAGEIF({formula1, formula2, etc},"<>0"). I haven't been able to figure out a way to feed AVERAGEIF individual values to average. I would think that =AVERAGEIF({3,7,0,4},"<>0") should be possible but again I haven't figured out how to make it work. BTW, the answer to the example should be 4.666 (i.e. 14/3). TIA
    Last edited by bird333; 06-18-2023 at 08:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. AVERAGEIF with dynamic range?
    By ceght in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2017, 08:17 AM
  2. [SOLVED] Averageif(range,monthcriteria,[average range])???
    By athyeh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2013, 12:09 PM
  3. Using averageif with dynamic range
    By davetcw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2013, 07:17 PM
  4. [SOLVED] averageif for date range
    By tbaron in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2013, 07:48 PM
  5. Excel 2007 : AVERAGEIF range function
    By Jerseynjphillypa in forum Excel General
    Replies: 1
    Last Post: 07-16-2012, 10:45 AM
  6. Excel 2007 : Using YEAR() of a range in AVERAGEIF
    By qaliq in forum Excel General
    Replies: 2
    Last Post: 11-01-2011, 09:17 AM
  7. AverageIf across a range of sheets
    By Ducjes in forum Excel General
    Replies: 4
    Last Post: 07-06-2010, 03:40 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