Page 435 - Excel 2013 All-in-One For Dummies

columns over (including column A with Part-131), you come to cell G4 in the Sep-13 column with the value 189.
Reference functions
The reference functions on the Lookup & Reference command button’s drop- down list on the Formulas tab of the Ribbon are designed to deal specifically with different aspects of cell references in the worksheet. This group of func- tions includes:
✦ ADDRESS to return a cell reference as a text entry in a cell of the worksheet
✦ AREAStoreturnthenumberofareasinalistofvalues(areasaredefined as a range of contiguous cells or a single cell in the cell reference)
✦ COLUMN to return the number representing the column position of a cell reference
✦ COLUMNS to return the number of columns in a reference
✦ FORMULATEXT to return the formula referenced as a text string
✦ GETPIVOTDATAtoreturndatastoredinanExcelpivottable(seeBookVII, Chapter 2 for details)
✦ HYPERLINK to create a link that opens another document stored on your computer, network, or the Internet (you can also do this with the Insert➪Hyperlink command — see Book IV, Chapter 2 for details)
✦ INDIRECT to return a cell reference specified by a text string and bring the contents in the cell to which it refers to that cell
✦ LOOKUP to return a value from an array
✦ OFFSET to return a reference to a cell range that’s specified by the
number of rows and columns from a cell or a cell range
✦ ROW to return the row number of a cell reference
✦ ROWS to return the number of rows in a cell range or array
✦ RTD to return real-time data from a server running a program that supports COM (Component Object Model) automation
✦ TRANSPOSE to return a vertical array as a horizontal array and vice versa
Get the skinny on columns and rows
The COLUMNS and ROWS functions return the number of columns and rows in a particular cell range or array. For example, if you have a cell range in the spreadsheet named product_mix, you can find out how many columns it contains by entering this formula:
Lookup and Reference 417
=COLUMNS(product_mix)
Book III Chapter 6
Lookup, Information, and Text Formulas