- https://blog.documentfoundation.org/blog/2020/08/05/announcement-of-libreoffice-7-0/
- https://blog.documentfoundation.org/blog/2020/01/21/odf-1-3-approved-as-oasis-committee-specification/
- https://en.wikipedia.org/wiki/OASIS_(organization)
- https://skia.org/
- https://en.wikipedia.org/wiki/Vulkan_(API)
- https://www.documentfoundation.org/governance/advisory-board/
- https://www.redhat.com/en
- https://www.collaboraoffice.com/
- https://www.cib.de/en/home.html
- https://www.ahuka.com/libreoffice-7-0-released/

`COUNTIF`

function of LibreOffice calc. In this episode I will go through some examples of ways that I've used `COUNTIF`

to generate reports.
Count occurrences of the string from A6 of current sheet on other sheet Personnel in column K

=COUNTIF($Personnel.$K$1:$K$135,Reports.A6)

Count occurrences of explicit string on other sheet "Personnel" in column K

=COUNTIF($Personnel.$K$1:$K$135,"=Instructor")

Count greater than or equal to 50

=COUNTIF($I$2:$I$105,">=50")

Using `SUMPRODUCT`

, count between range greater than or equal to 40 but less than 50

=SUMPRODUCT($I$2:$I$105>=40,$I$2:$I$105<50)

Look for the string from sheet "Reports," cell A21, in the sheet "Personnel" column U, excluding any rows that have the value "Adjunct" in column K.

=COUNTIFS($Personnel.$U$1:$U$135,Reports.A21,$Personnel.$K$1:$K$135,"<>Adjunct")]]>

There is a lot to know about Charts if you are going to use them effectively, and we covered all of this in our Calc tutorials. For more go to http://www.ahuka.com/?page_id=1291