+ Reply to Thread
Results 1 to 3 of 3

Need formula that calculates AVG number based on exact criteria

  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    Latvia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Wink Need formula that calculates AVG number based on exact criteria

    Hi!

    I would need your help - is there any formula that could help me to calculate total average number of recruitment days (i'ts one number), but only for "Diana" and "Skipper" (excluding "Jennifer")?

    Please see an example:

    Recruitment days Responsible
    12 Diana
    13 Diana
    19 Diana
    16 Skipper
    23 Jennifer
    24 Diana
    26 Diana
    29 Diana
    30 Diana
    34 Jennifer
    36 Skipper
    29 Skipper
    12 Diana
    11 Skipper
    1 Skipper
    30 Diana
    12 Jennifer
    16 Jennifer
    17 Diana
    21 Jennifer


    I guess it has something to do with AVG and IF formulas, but I need your help!
    Many thanks!

    Lindee

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need formula that calculates AVG number based on exact criteria

    Hi, and welcome to the forum

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-14-2014
    Location
    Latvia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need formula that calculates AVG number based on exact criteria

    Many thanks Richard, you really helped me! :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-16-2013, 07:44 AM
  2. Formula to work out an exact average over an exact number
    By Sandyshirl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-11-2013, 01:35 AM
  3. Replies: 1
    Last Post: 03-11-2010, 09:12 AM
  4. Sum exact range based on criteria
    By exceldiehardfan in forum Excel General
    Replies: 4
    Last Post: 02-23-2010, 11:26 PM
  5. Replies: 11
    Last Post: 11-12-2009, 03:25 PM

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