OpenOffice Calc
Master Every Cell
Learn formulas, functions, data tools, formatting, and advanced spreadsheet techniques for OpenOffice Calc.
Explore OpenOffice Calc functions
Browse 153 individual function guides, with examples and troubleshooting notes.
View all 153 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 …