Results 1 to 8 of 8

HELP Averageifs multiples

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    4

    HELP Averageifs multiples

    Hi Guys I am new here, and I will introduce my self properly soon.

    I have a problem.
    here is an example
    (Column A) (Column B) (Column C) (Column D) (Column E)
    LAST_NAME FIRST_NAME GENDER AGE Job Role
    James wo m 20 DR
    B ho m 30 Junior DR
    C chow F 10 Junior DR
    D lee F 10 Junior DR

    Average the Age

    Okay so I know how to averageIf, for one criteria. EG. =Averageif(D:D,C:C,"M",E:E,"DR")


    Now the problem is that I want an Averageifs on Junior Dr(s), how do I write it??
    help please
    Last edited by kenzotokyo; 12-11-2014 at 06:35 AM. Reason: formatting

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiples of two numbers
    By Reapz in forum Excel General
    Replies: 6
    Last Post: 06-05-2014, 01:06 PM
  2. Multiples of Numbers
    By scantor145 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2012, 02:06 PM
  3. Rounding from multiples
    By Audiguy82 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-03-2007, 04:31 PM
  4. [SOLVED] MAX, IF multiples
    By holyman in forum Excel General
    Replies: 6
    Last Post: 06-30-2006, 10:25 AM
  5. Multiples....
    By Cam in forum Excel General
    Replies: 14
    Last Post: 05-18-2006, 04:33 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