Results 1 to 4 of 4

Using Average and ignoring cells with #div/0

Threaded View

  1. #1
    Registered User
    Join Date
    10-13-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    2010
    Posts
    99

    Using Average and ignoring cells with #div/0

    Hello,
    I've attached an image below but I'm not sure you can see it. Jan - Dec and YTD average are in cells I5 to I17 and their corresponding values are in cells J5 to J17.

    I need to average the column of twelve monthly percentage scores. The problem I'm having is that the cells all pull their own values from other cells on the same sheet. The values are averages of each month, Jan, Feb, etc. Those other cells are currently blank. For example, lets say this is March 2015. I have scores for January, February, and March but April to December are all empty so the values in those cells are all #div/0. How do I calculate a year to date average for the year while ignoring the cells with #div/0?

    Thanks for your help
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumproduct Average ignoring blank cells
    By fgruhlke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2014, 12:32 PM
  2. Average Ignoring Zero Values - Non-consecutive cells
    By a7mad3wies in forum Excel General
    Replies: 2
    Last Post: 12-05-2013, 02:13 AM
  3. Getting average but ignoring cells with blank (#value!)
    By Elainefish in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-23-2013, 08:30 AM
  4. Average ignoring Blanks cells
    By Justinmih in forum Excel General
    Replies: 10
    Last Post: 09-30-2011, 06:21 PM
  5. [SOLVED] 30 Day Moving Average Ignoring Blank Cells
    By ethatch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2006, 05:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1