MicroSheet — your local spreadsheet

Formula quick guide

Start with =. Use numbers, cell references, parentheses, and + − × ÷ (type + - * /). Click a cell to add a reference or drag to add a range.

SUMAdds numeric cells; blanks are ignored.=SUM(A1:A10)

AVERAGEAverages numeric cells; blanks are ignored.=AVERAGE(A1:A10)

References & arithmeticCombine cells with normal math.=(A1+B1)/2

Tip: $A$1 stays fixed when you fill or copy a formula. Press Enter to save; Escape to cancel.