Formulas and functions
SUM, IF, VLOOKUP, and cell references.
Enter formulas
Start with = in any cell. Use SUM, AVERAGE, IF, VLOOKUP, COUNTIF.
References
Relative (A1) and absolute ($A$1) references when copying.
Error codes
#REF!, #VALUE! — check ranges and data types.
Was this article helpful?