SUM and AVERAGE
MAX and AVERAGE
LABEL and AVERAGE
MIN and BLANK
It includes column and row references.
It adjusts to its location on the worksheet.
It refers to an existing cell on the worksheet.
It resets to its original value.
It adds the values in cells D7:D14 if the value is greater than 1.
It adds all the negative values in cells D7:D14.
If the value in a cell is greater than 1, it is added to the other values in column D.
If the value in a cell is greater than 1, the range D7:D14 is placed on a summary sheet.
1, 3, 5, 7
7, 5, 3, 1
Tom, John, Adam
May 1, 2007; April 1, 2007; March 1, 2007
Lookup and Reference
They are easier to remember than cell addresses.
They can be used for navigation.
They automatically substitute the relevant cell addresses.
They make formulas easier to understand.
Visual Basic scenario
Visual Basic routine
They allow you to add dynamic data.
They allow you to rearrange row and column data.
They allow you to generate e-mail enabled reports.
They allow you to print the reports with various settings.