Data from another sheet

[cheverin]

Hello! I am trying to write a formula, but I need to use data from another sheet. How can I use that data from the other sheet in a formula on a different sheet?

[#2]

You can include the sheet name in the range reference (if there are spaces in the sheet name then you need a single apostrophe ' around the sheet name): =Sum('Some Other Sheet'!A1:A10) But, as you are entering the formula, you can click on the other worksheet and select the range and let excel do the work.

[#3]

@cheverin 

With the permission of everyone involved. Here is a file to supplement the very good explanation by Mr.Jeff Blakley (@JMB17)

There are many roads that lead to Rome. This is also the case with Excel, it is recommended to insert a file (without sensitive data) to explain your project exactly.

Have a nice day / night and thank you for your patience.

Nikolino
I know that I don't know anything (Socrates)