|
A partire da gennaio 2021, i tipi di file classici non potranno più essere utilizzati. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Sum 2 cells from different file in one cell

Con risposta
Richiedi una demo

I have a Source file with 2 cells, I need to Sum those 2 cells and Link it in my Destination File. How to do it?

1

Commenti

1 commento

Data Voti
  • Commento ufficiale
    Isabel Messore
    Here's how to SUM two cells in your Source file and link the result to your Destination file:

    Step 1: Create the SUM formula in your Source file
    • In a third cell of your Source spreadsheet, enter the SUM formula:  =SUM(A1, B1) (replace A1 and B1 with your actual cell references)
    • This cell will now display the summed result.
    Step 2: Create a Source Link from the SUM cell
    • Select the cell containing the SUM result.
    • Copy it using Ctrl+C (Windows) or ⌘+C (Mac).
    Step 3: Paste into your Destination file
    • Open your Destination file and navigate to the cell where you want the linked value.
    • Paste using Ctrl+V (Windows) or ⌘+V (Mac).
    • Click the blue clipboard icon that appears.
    • Select Create Links From and choose the appropriate option.
    • Click Apply to finalize the link.
    The pasted cell becomes the destination link, and the SUM cell in your source is the source link (shown with a blue indicator ).

    Step 4: Publish your link
    • Whenever you update values in the source cells, an orange indicator will appear showing unpublished changes.
    • Click Publish in the toolbar to push the updated value to your destination link.

Accedi per aggiungere un commento.