1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Average IF

Discussion in 'Business Applications' started by VJAN, Jun 16, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. VJAN

    VJAN Thread Starter

    Joined:
    Nov 19, 2009
    Messages:
    35
    Want to bring the Avg Amount, using IF Formula for the below calculations.
    This Sheet 2
    ColumnA Column B
    Grade Group
    Avg Amount
    A&B
    This Sheet 2
    C&D

    E&F

    G&H

    I&J

    Total




    The below data is on Sheet 3 from where the data needs to be taken for the above function
    Employee Code
    Employee Name
    Grade
    Amt
    0020
    Tom
    B
    24970
    0024
    Dick
    I
    24970
    0030
    Heera
    B
    24970
    3933
    Hari
    I
    10822
    3935
    P C
    C
    10822
    3936
    Vivek
    J
    10822
    3937
    Keni
    G
    10822
    0115
    atil
    D
    24970
    3939
    Swam
    J
    10822
    0166
    Samir
    A
    24970
    3940
    Taran
    H
    10822
    3941
    Sathya
    G
    10822
    3942
    Seem
    A
    10822
    0236
    Santos
    G
    24970​


    Can u please help me with the Average if function.
     
  2. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    As you can see, what you type in doesn't hold formatting well. Please use the Go Advanced button and upload a copy of your file with fake data in it.
    Also, enter what you want as a result.
    (Note, I don't have 2007, but I am pretty sure I understand the formula and can write it for you.)
     
  3. VJAN

    VJAN Thread Starter

    Joined:
    Nov 19, 2009
    Messages:
    35
    Please see the attach file,while the query is been written in it.
     

    Attached Files:

  4. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Average IF only allows one criteria, and since you wanted to combine two (e.g. A and B) I just wrote some regular IF formulas.
     

    Attached Files:

  5. VJAN

    VJAN Thread Starter

    Joined:
    Nov 19, 2009
    Messages:
    35
    Thank Slurpee
     
  6. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Glad to help! Please use the button at the top of the page to mark this thread as Solved. :)
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/929569

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice