In this edition of Serge Explains we take another look at LibreOffice Calc, specifically the IF statements. These include COUNTIF, AVERAGEIF and SUMIF as well as the IFS statements of the same type. Serge walks through examples of how to use these formulas and how they can be useful to you in filtering data within a spreadsheet.
IF Statements:
01:25 COUNTIF
08:45 SUMIF
15:30 AVERAGEIF
IFS Statements:
18:30 COUNTIFS
26:14 SUMIFS
30:58 AVERAGEIFS
#libreofficecalc #spreadhseet #tutorial
5 окт 2024