The tutor shows the neat function sumif() found on Excel and also on LibreOffice Calc.

At its simplest, the sumif() function adds the members of a range that meet a certain condition; those that don’t, aren’t included in the sum. For instance, let’s imagine a spreadsheet that contains the following values in cells a1 to a4:

101
96
55
78

Let’s imagine, for instance, that entered into a10 is the formula

=sumif(a1:a4,”<90")

It will return the result 133.

The sumif() function has more complex possibilities as well, which I will pursue in a future post:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.