LibreOffice Calc

Master Every Cell

Learn formulas, functions, data tools, formatting, and advanced spreadsheet techniques for LibreOffice Calc.

Explore LibreOffice Calc functions

Browse 391 individual function guides, with examples and troubleshooting notes.

View all 391 functions →

Featured function guides

SUMThe SUM function in LibreOffice Calc adds numbers, cell ranges, or mixed arguments. Learn syntax, examples, common errors, and best … COUNTIFThe COUNTIF function in LibreOffice Calc counts cells that meet a single condition. This guide explains syntax, operators, wildcards, … XLOOKUPLearn the XLOOKUP function in LibreOffice Calc: Extended vertical search and reference to indicated cells. FILTERAn explanation of LibreOffice Calc FILTER, including tested formulas, examples, expected results and common mistakes. SORTAn explanation of LibreOffice Calc SORT, including tested formulas, examples, expected results and common mistakes. LETAn explanation of LibreOffice Calc LET, including tested formulas, examples, expected results and common mistakes.

LibreOffice tutorials and troubleshooting

See all tutorials →

Fix CSV importsChoose the right separator when all fields appear in one column. COUNTIF returns 0Find hidden spaces, wrong ranges and criteria mismatches. Fix Err:502Diagnose invalid arguments with reproducible examples.

More LibreOffice Calc functions

Browse A–Z →