The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

This formula shows how to reference the cell in another worksheet using a formula. Begin the formula with an equal sign, and follow it with the name of the worksheet you wish to reference.

How to Cross Reference Between Excel Spreadsheets. Each cell in an Excel spreadsheet has a unique address, called a cell reference. This reference combines the letter that represents the cell's ...

Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell.