COUNTIFS

Google-Sheets

Definition

Returns the count of cells meeting multiple criteria across ranges.

Example

=COUNTIFS(A1:A10, ">0", B1:B10, "East") counts rows where A>0 and B="East".

Stop Juggling Dashboards. Start Growing Get your data flowing today, free plan available.