Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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?
Since you have already tried the query solution, please use these two formulas:
in cell B2:
=query(D6:E10, "select count(D) where D='paid' and E='MB' label count(D) ''")
in cell D2:
=query(D6:E10, "select count(D) where D='paid' and E='UB' label count(D) ''")
You can read more about how the QUERY function works in the help center.
Note: In the end of the formula we use label count(D) ''. That translates to "take the label of the results in column D and replace it with nothing. Try omitting that part of the formula and see what happens ".
#N/A if there is no data, no match?
#N/A. If there is no data/match the query would have a red line under it saying "Query completed with an empty output". You must be referring to a different formula. Please share a link and maybe start another question. In any case the usual way is to use IFERROR.
Oct 9, 2019 at 6:19
=IFERROR(query(D5:EG113, "select count(E) where E='UB' label count(E) ''"),"")