+ Reply to Thread
Results 1 to 2 of 2

Need help with averaging every other cell column and leaving out the #DIV/0!

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    Rochester, MN
    MS-Off Ver
    Excel 2010
    Posts
    2

    Need help with averaging every other cell column and leaving out the #DIV/0!

    I'm putting together a page that transfers %'s from one sheet to another, then on the new sheet, i need to get the average percentage from every other column cell and ignore any #DIV/0! that might copy over from lack of info.
    I am an excel beginner and using a formula that looks like this =AVERAGE(C3,E3,G3,I3,K3,M3,O3,Q3,S3,U3,W3,Y3) to get the average in cell AA, but ofcourse if a #DIV/0! is involved it wont work. whats the best way to write the formula so that I can get the result i'm looking for? Any help is appreciated!

  2. #2
    Registered User
    Join Date
    03-14-2013
    Location
    Rochester, MN
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need help with averaging every other cell column and leaving out the #DIV/0!

    I found a previous thread that had a formula I could use, thank your guys for this forum.

    =LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,AVERAGE(IF(ISNUMBER(C2:Y2)*(MOD(COLUMN(C2:Y2),2)=1),C2:Y2))))

+ Reply to Thread

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