Results 1 to 9 of 9

Mixing AVERAGEIF() with OR() & AND()

Threaded View

gdel Mixing AVERAGEIF() with OR()... 09-05-2013, 09:00 AM
Tony Valko Re: Mixing AVERAGEIF() with... 09-05-2013, 09:12 AM
gdel Re: Mixing AVERAGEIF() with... 09-05-2013, 09:12 AM
Tony Valko Re: Mixing AVERAGEIF() with... 09-05-2013, 09:38 AM
Debraj Roy Re: Mixing AVERAGEIF() with... 09-05-2013, 09:23 AM
gdel Re: Mixing AVERAGEIF() with... 09-05-2013, 09:31 AM
XOR LX Re: Mixing AVERAGEIF() with... 09-05-2013, 09:23 AM
gdel Re: Mixing AVERAGEIF() with... 09-05-2013, 09:32 AM
XOR LX Re: Mixing AVERAGEIF() with... 09-05-2013, 09:39 AM
  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    11

    Mixing AVERAGEIF() with OR() & AND()

    I'm having the issue where I need to mix an averageif, with multiple conditions, some OR and some AND.

    I've started with:

    =average(AVERAGEIFS(AI:AI,U:U,"Photo",D:D,"July 2013"),averageifs(AI:AI,U:U,"Photo",D:D,"Aug 2013")), but this doesn't average the full set together.

    The logic I need to accomplish is, average range AI:AI IF U:U=Photo AND D:D="Aug 2013" OR D:D="Jul 2013"

    Any ideas?

    Thanks in advanced!
    -G
    Last edited by gdel; 09-05-2013 at 09:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. mixing up numbers
    By aquinlan in forum Excel General
    Replies: 0
    Last Post: 10-13-2011, 01:20 PM
  2. mixing numbers up
    By Duckie in forum Excel General
    Replies: 6
    Last Post: 08-02-2009, 08:04 AM
  3. Mixing two columns
    By etrader in forum Excel General
    Replies: 5
    Last Post: 07-16-2009, 03:03 PM
  4. [SOLVED] Mixing AND & OR functions
    By Barney in forum Excel General
    Replies: 2
    Last Post: 07-02-2006, 03:50 PM
  5. Mixing up the arguments
    By michaelr586 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2005, 05:05 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