+ Reply to Thread
Results 1 to 2 of 2

A1 in sheet1 = =SUM('sheet2:sheet3'!A1)

  1. #1
    Registered User
    Join Date
    08-11-2005
    Posts
    21

    A1 in sheet1 = =SUM('sheet2:sheet3'!A1)

    When a row is inserted above A1 for sheet 2 and sheet3, the A1 in sheet1 should automatically = =SUM('sheet2:sheet3'!A2). Does anyone know how to update this change automatically?

  2. #2
    Ron de Bruin
    Guest

    Re: A1 in sheet1 =" =SUM('sheet2:sheet3'!A1)"

    Hi minrufeng

    You must select(group) sheet2 and sheet3 before you insert the row


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "minrufeng" <minrufeng.23n7qy_1140632102.0653@excelforum-nospam.com> wrote in message
    news:minrufeng.23n7qy_1140632102.0653@excelforum-nospam.com...
    >
    > When a row is inserted above A1 for sheet 2 and sheet3, the A1 in sheet1
    > should automatically =" =SUM('sheet2:sheet3'!A2)". Does anyone know how
    > to update this change automatically?
    >
    >
    > --
    > minrufeng
    > ------------------------------------------------------------------------
    > minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208
    > View this thread: http://www.excelforum.com/showthread...hreadid=515443
    >




+ 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