+ Reply to Thread
Results 1 to 3 of 3

averageifs formula doesnt change when autofilled

  1. #1
    Registered User
    Join Date
    11-30-2011
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    12

    averageifs formula doesnt change when autofilled

    =AVERAGEIFS(M:M,I:I,1,A:A,1)

    Above is the formula in question.

    When I drag down, I want it to be able to change from the above to =AVERAGEIFS(M:M,I:I,2,A:A,1) and so on as it is autofilled.

    Even if I type a second and third one in, it just loops those, rather than adding 1 to the value in the middle of the formula.

    Anyone know how to make it do this?

    Thanks.
    Last edited by jacobhandson; 01-29-2012 at 09:33 PM.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: averageifs formula doesnt change when autofilled

    =AVERAGEIFS(M:M,I:I,ROWS($1:1),A:A,1)

    copy down.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    11-30-2011
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: averageifs formula doesnt change when autofilled

    fantastic, thanks a lot. i knew it would be something to do with references but none of the things i tried had worked.

    cheers,

    jacob

+ 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