|Access||Adobe photoshop||Algoritmi||Autocad||Baze de date||C||C sharp|
|Calculatoare||Corel draw||Dot net||Excel||Fox pro||Frontpage||Hardware|
|Php||Power point||Retele calculatoare||Sql||Tutorials||Webdesign||Windows|
|Asp||Autocad||C||Dot net||Excel||Fox pro||Html||Java|
A 3D reference is one that includes a reference to one or more cells that is not on the same worksheet as the formula. For example, you might create a Summary sheet that pulls in totals from each of several other sheets in the workbook.
You're already familiar with the way area codes in phone numbers work, right? When you're dialing a number that's within your area code, you usually don't have to dial the area code. It's only when you're calling outside it that the area code becomes necessary.
It's the same thing with sheet names. If a formula refers to a cell on the same sheet, the sheet name can be left out; otherwise, it must be included.
Sheet names appear in formulas with an exclamation point after their names, like this:Sheet1!
So, for example, if I want to refer to cell A2 on Sheet2, the full way of expressing that isSheet2!A2
Ranges work the same way. The range of A2:C6 on Sheet2 isSheet2!A2:C6
If you only want to repeat the value of whatever is in the cell, just precede it with an equal sign:=Sheet2!A2
You can also use it in calculations, just like a normal cell or range. For example:=SUM(Sheet2!A2:C6)
If you don't remember the sheet name and it isn't convenient to look it up, you can create a formula by selecting instead. Let's say, for example, that you want to create the preceding formula example by selecting. Here's how you would do it:
You can also use this process to refer to cells and ranges in other workbooks.
Politica de confidentialitate|
Termeni si conditii de utilizare | Contact
© SCRIGROUP 2023 . All rights reserved