https://docs.google.com/spreadsheets/d/1PlPmShZ4SnkxAqBTg5xY_LHaNokGaFli4Wc7MjV_Jqo/edit?usp=sharing
I want to count how many paid
is for city MB
and then how many paid
is for city UB
.
I tried to use COUNTIFS and =COUNTA((QUERY(C4:C42, "select D where D='paid' and C='MB'", 0)))
but I cannot make it work.
Somebody got an idea?