Results 1 to 9 of 9

averaging formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-11-2008
    MS-Off Ver
    2003
    Posts
    220

    averaging formula

    I currently have a formula which looks like this:

    =AVERAGE(E9*D9,E10*D10,E11*D11,E12*D12,E13*D13,E14*D14,E15*D15,E16*D16,E17*D17,E18*D18)/AVERAGE(D9:D18)

    Currently Cells E13,D13,E14,D14,E15,D15,E16,D16,E17,D17,E18,D18 are empty but would eventually become filled which is why i have included them in the average formula above. However it is obviously lowering the average because it is counting the cells that are empty as zero. I have been trying to use an IF FORMULA to correct this but as of yet have not managed it.

    Am i pointing in the right direction, or perhaps someone could suggest an alternative formula.....thanks for your help!!!!
    Last edited by oldchippy; 11-09-2008 at 11:48 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for bond price
    By Dracan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 11:17 AM
  2. averaging calls per hour formula assistance
    By iggyfalk in forum Excel General
    Replies: 2
    Last Post: 07-29-2008, 11:18 AM
  3. Formula needed to tell me if a value exists
    By WhatF in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2008, 08:16 AM
  4. Conditional formula question
    By odditie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2007, 09:47 PM
  5. How do I subsitute part of a formula linked to another workbook?
    By Scej12 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-03-2007, 10:10 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