Results 1 to 10 of 10

Averageif, not counting zeros, but in multiple ranges)

Threaded View

  1. 05-14-2015, 06:14 PM #1
    Alphabex
    Alphabex is offline
    Registered User
    Join Date
    01-15-2015
    Location
    California
    MS-Off Ver
    2010
    Posts
    96

    Thumbs up Averageif, not counting zeros, but in multiple ranges)

    I need to return an average for the following ranges E5, E9:13, E17:21, E25:29, E34:37 only and not count any zeros. I have tried multiple options with sum/countif, averageif, etc., and I must be missing something. If there a solution? TIA
    Last edited by Alphabex; 05-15-2015 at 01:18 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to define multiple ranges with AVERAGEIF().
    By Snoddas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2018, 11:50 PM
  2. AVERAGEIF for multiple ranges
    By soccow in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-17-2012, 06:58 PM
  3. [SOLVED] AVERAGEIF / SUMIF with multiple ranges
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2012, 01:26 PM
  4. SUMIF/AVERAGEIF with multiple ranges
    By Cassi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2011, 11:10 AM
  5. AverageIf Formula Counting zeros grrr
    By AllenMead in forum Excel General
    Replies: 3
    Last Post: 10-31-2010, 11:41 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1