Results 1 to 8 of 8

Excel 2007 : SUMIFS Formula Not Working

Threaded View

milliemoo SUMIFS Formula Not Working 03-06-2012, 11:46 AM
Andrew-R Re: SUMIFS Formula Not Working 03-06-2012, 11:51 AM
tigeravatar Re: SUMIFS Formula Not Working 03-06-2012, 11:52 AM
milliemoo Re: SUMIFS Formula Not Working 03-06-2012, 11:56 AM
milliemoo Re: SUMIFS Formula Not Working 03-06-2012, 12:01 PM
milliemoo Re: SUMIFS Formula Not Working 03-06-2012, 12:06 PM
tigeravatar Re: SUMIFS Formula Not Working 03-06-2012, 12:09 PM
milliemoo Re: SUMIFS Formula Not Working 03-06-2012, 12:16 PM
  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    51

    SUMIFS Formula Not Working

    Hello, I have written a formula to calculate the average values in column AE (based on several other conditions), as per the following:

    =SUM(SUMIFS(AE:AE,AA:AA,"Arabica Shift",AB:AB,">0",AD:AD,">0",F:F,"No"))/SUM(COUNTIFS(AA:AA,"Arabica Shift",AB:AB,">0",AD:AD,">0",F:F,"No",D:D,"1"))

    At the moment I am getting an error message but I can't spot my mistake....is anybody able to help, please? Do you need to know what all the other column references?

    I am trying to calculate the average value in column AE if.... AA=Arabica Shift, AB>0, AD>0, F="No", D="1"


    Many Thanks
    Last edited by milliemoo; 03-06-2012 at 12:17 PM. Reason: SOLVED

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