COUNTIF and COUNTIFS

Count records that match one or several criteria.

Practical example

=COUNTIFS(B:B, "Open", C:C, ">30")

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.