+ Reply to Thread
Results 1 to 2 of 2

Make an array stay the same when autofill (absolute reference)

  1. #1
    Registered User
    Join Date
    08-30-2010
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    7

    Make an array stay the same when autofill (absolute reference)

    Hi,

    I have this array formula in E5:
    {=SUM(C7:C47*E7:E47)}

    I need to autofill from E5 up to the end of the row but only the E7:E47 array needs to change. The C7:C47 has to stay the same.

    I tried
    {=SUM($C7:$C47*E7:E47)}

    but it gives me a VALUE error

    How can I make the C array an absolute reference?

  2. #2
    Registered User
    Join Date
    08-30-2010
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Make an array stay the same when autofill (absolute reference)

    Please ignore this message

    I fixed it by using

    {=SUM($C$7:$C$47*E7:E47)}

+ 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