Write formulas
Calculate with formulas that use cell references, operators and functions.
On this page
- Select a cell and type
=. - Type the formula, for example
=A2*B2or=SUM(B2:B10). Click cells to add their references. - Press Enter.
References
A1is relative: it changes when you copy the formula.$A$1is absolute: it stays the same. Press F4 while editing to switch.Sheet2!A1refers to another sheet.- Named ranges let you write
=SUM(Sales)instead of a range.
AutoSum
Select the cell below a column of numbers and choose AutoSum on the Home tab.
Tip
Formulas that return several values, like =UNIQUE(A2:A100) or =SORT(...), spill into the cells below.
Was this article helpful?
Related articles
- Find and use functionsSearch more than 350 functions with help and examples in your language.
- Fix formula errorsWhat #DIV/0!, #NAME?, #VALUE!, #REF!, #N/A and #SPILL! mean and how to fix them.
- Fill cells and series automaticallyDrag the fill handle to copy values or continue series such as dates, numbers and weekdays.
Still need help?
Write to the Woosool team. Sign in with your Woosool Account and we reply by e-mail and in My requests.