|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 range is a range that includes the same cell(s) on more than one sheet. This can be helpful when you have multiple sheets that all contain basically the same information but for different groups, people, organizations, months, or other distinguishing factor. You can use a 3D range to perform calculations upon the same fields on each of the sheets.
For example, suppose you have 12 worksheets, one for each month of the year. On each sheet, cell D12 contains the total sales. You could create a SUM function that uses as its range the contents of cell D12 on each of the sheets.
To create a 3D range:
You can also manually write a 3D range in a formula. Simply refer to the sheet names in a range, with the first and last sheet names separated by a colon. For the earlier example with 12 months of sheets and summing the values in D12, the formula would look like this:
Of course, in real life, you'd probably have named the worksheet tabs for each month, so it might look more like this:=SUM(January:December!D12)
Politica de confidentialitate|
Adauga cod HTML in site