Excel's COUNT function produces a number of cells containing any value, but only COUNTIF and COUNTIFS can use conditions to ...

Before we look at how it works in practice, let's run through the syntax. The OFFSET ... I'll use the COUNTIF function with a wildcard to tell Excel to count how many cells in row 1 contain ...