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

  • Thread starter Thread starter minrufeng
  • Start date Start date
M

minrufeng

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement mySum(Sheet1:Sheet3!B1)? 8
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updat 2
My Never ending ARRAY code problems 18
Macro to change the column references automatically 2
summing accross multiple sheets 4
conditional copy and paste 11
Populating a range of empty cells with usernames 4
Convert A1 value to a sheet name and copy to it 2

Back
Top