Conditional Countifs Google Sheet

Question

enter image description here

So basically on (Column Team) I have a "Talaga & Burot" and on (Column Status) i have "On Time & Slow" Countif are not working, What I want to be done is, I can count how many slow and on time burot have, and how many slow and on time talaga have.

Answer 1

Assuming the 'Team' column is column A and the 'Status' column is column B, you can try

=query(A2:B, "Select A, count(A) where A <>'' group By A pivot B", 0)

Change range to suit and see if that works for you?

Reference

• Query()