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

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?
 
R

Ron de Bruin

Hi minrufeng

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

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
conditional copy and paste 11
Populating a range of empty cells with usernames 4
Copy from sheet1 and sheet2 and append to sheet3 in different format 8
Read and search 2

Top