+ Reply to Thread
Results 1 to 3 of 3

Need help with averageif Function

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    118

    Need help with averageif Function

    Hello friends

    I have a sheet which contains data in particular format:
    ColumnA ColumnB ColumnC ColumnN
    Oct-12 Department Site1 score
    Oct-12 Department Site1 score
    Oct-12 Department Site2 score
    Oct-12 Department Site4 score

    The below formula gives me #NA:

    =AVERAGE(IF((MONTH('Data'!$A$2:$A$65535)=10)*(YEAR('Data'!$A$2:$A$65535)=2012),IF('Data'!$B$2:$B$65536="Department",IF('Data'!$C$2:$C$65536="Site",'Data"!$N$2:$N$65536))))


    I need the Average of a department for a particular site in the month for oct or sept.


    Help would be appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,244

    Re: Need help with averageif Function

    2 comments...
    1. try using averageif()
    2. it doesnt look like you have any actual values in you're sample to average?

    i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, what your expected outcome is, and how you arrived at that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    07-30-2012
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    118

    Re: Need help with averageif Function

    Quote Originally Posted by FDibbins View Post
    2 comments...
    1. try using averageif()
    2. it doesnt look like you have any actual values in you're sample to average?

    i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, what your expected outcome is, and how you arrived at that


    I am having problem with this formula as well

    =SUMPRODUCT((Data!$C$3:$C$65535="Site")*(Data!$B$3:$B$65535="Department")*(MONTH(Data!A3:A65535="10")*(YEAR(Data!$A$3:$A$65535="2012")*(Data!$N$3:$N$65535))))

    The score are different percentage.I am working on 2003 file.

+ Reply to Thread

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