Apache OpenOffice Calc
Master Every Cell
Learn formulas, functions, data tools, formatting, and advanced spreadsheet techniques for Apache OpenOffice Calc.
Explore Apache OpenOffice Calc functions
Browse 396 individual function guides, with examples and troubleshooting notes.
View all 396 functions →Featured function guides
sumThe SUM function in OpenOffice Calc adds numbers, cell ranges, or mixed arguments. Learn syntax, examples, common errors, and best …
countifThe COUNTIF function in OpenOffice Calc counts cells that meet a single condition. Learn syntax, examples, wildcard rules, common errors, …
VLOOKUPLearn the VLOOKUP function in Apache OpenOffice Calc: Vertical search and reference to indicated cells.
MATCHLearn the MATCH function in Apache OpenOffice Calc: Defines a position in an array after comparing values.
averageifsThe AVERAGEIFS function in OpenOffice Calc calculates the average of values that meet multiple conditions. Learn syntax, examples, wildcard …