Results 1 to 14 of 14

Average If...

Threaded View

RyanNoodles Average If... 09-07-2012, 07:55 AM
Ace_XL Re: Average If... 09-07-2012, 08:03 AM
K m Re: Average If... 09-07-2012, 08:07 AM
RyanNoodles Re: Average If... 09-07-2012, 08:22 AM
K m Re: Average If... 09-07-2012, 08:28 AM
RyanNoodles Re: Average If... 09-07-2012, 09:45 AM
Ace_XL Re: Average If... 09-07-2012, 09:48 AM
RyanNoodles Re: Average If... 09-07-2012, 10:05 AM
Kevin UK Re: Average If... 09-07-2012, 09:53 AM
RyanNoodles Re: Average If... 09-07-2012, 11:25 AM
Kevin UK Re: Average If... 09-07-2012, 11:28 AM
RyanNoodles Re: Average If... 09-07-2012, 11:31 AM
RyanNoodles Re: Average If... 09-07-2012, 12:09 PM
icestationzbra Re: Average If... 09-07-2012, 01:12 PM
  1. #3
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Average If...

    IF(B4=AT3,"(=AVERAGE(U4,W4,AA4,AE4,AG4,AK4))")

    The Blue part of your formula is wrong
    This formula will work but you had only one condition, I added the second condition as a blank ""
    =IF(B4="AT3",AVERAGE(U4,W4,AA4,AE4,AG4,AK4),"")

    Excel would interprete AT3 as cell AT3 not course AT3. That's why that is in quotes

    A sample workbook might help
    Last edited by K m; 09-07-2012 at 08:09 AM.
    Click on star (*) below if this helps

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