This tutorial explains how to perform SUMPRODUCT in LibreOffice Calc.
Tag: COUNTIF
This tutorial would explain various ways of COUNTIF function in LibreOffice Calc which can be used to count strings, numbers from a cell, range, rows, columns etc.