Results 1 to 4 of 4

HELP Subtracting averages when some cells have no values

Threaded View

  1. #1
    Registered User
    Join Date
    01-03-2012
    Location
    Frederick, MD
    MS-Off Ver
    Excel 2007
    Posts
    4

    HELP Subtracting averages when some cells have no values

    Below I have provided an example of what I am looking for. Basically I need to subtract two averages. Average of Rows 2-100 minus the average of row 1. Row 1 will be subtracted from the average of every other row. Here is the tricky part if for example row 3 does not have a value in cell B3 or C3 then I need the average of row 1 to exclude B1 and C1 from its calculation.

    A B C
    1 - 69.1 72 71

    2 - 85 83 84 this would be the average of 85,83,84(84) minus the average of 69.1,72,71(70.7) result should be 84-70.7=13.3
    3 - 86 this would be the average of 86(86) minus the average of 69.1(69.1) result should be 86-69.1=16.9
    4 - 87 90 this would be the average of 87,90(88.5) minus the average of 69.1,72(70.55) result should be 88.5-70.55=17.95

    Please help. All suggestions are appreciated.
    Attached Files Attached Files
    Last edited by ztaylor0; 03-26-2013 at 08:11 PM.

Thread Information

Users Browsing this Thread

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

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