I'm facing this issue

using this file I want to a query in the dashboard sheet in the area of A8 I have four columns that i want I want a column of the month a column of the services provided which came from a google sheet which is a checkbox question so sometimes it has 2 services, and column of the name of the con. now i want a dashboard to show the month and the number of services provided which correspond to the name of the service on the side bc sometimes there will be 2 services in one cell, i have created a dropdown in b2 with the months eg (February 2025) and a dropdown for the names of the con in d3 but i still get and empty list no matter what i try, this is an example file

this is a visual example of what I'm looking for, if the service = 0 I don't want it to show

I tried query but I couldn't add count if to it,

I want something like this

I'm facing this issue

using this file I want to a query in the dashboard sheet in the area of A8 I have four columns that i want I want a column of the month a column of the services provided which came from a google sheet which is a checkbox question so sometimes it has 2 services, and column of the name of the con. now i want a dashboard to show the month and the number of services provided which correspond to the name of the service on the side bc sometimes there will be 2 services in one cell, i have created a dropdown in b2 with the months eg (February 2025) and a dropdown for the names of the con in d3 but i still get and empty list no matter what i try, this is an example file

this is a visual example of what I'm looking for, if the service = 0 I don't want it to show

https://docs.google.com/spreadsheets/d/1CEfp-h5U4hRsiTGZoUdxdMq74sdcZgc7nuhr1cj2pFI/edit?usp=sharing

I tried query but I couldn't add count if to it,

I want something like this

• google-sheets

• Please provide enough code so others can better understand or reproduce the problem. – Community Bot Commented yesterday
• 1 Welcome to Stack Overflow. Please edit your question and insert a table of sample data together with another table that shows your manually entered desired results. – doubleunary Commented yesterday
• 1 Exact copy of query function with count if or another better idea for a dashboard. See Be Forthright When Cross Posting To Other Sites. – doubleunary Commented yesterday
• Make sure to provide input and expected output as plain text table in the question. Check my answer or other options to create a table easily, which are easy to copy/paste. Avoid sharing links like spreadsheets, which make the question useless for others or images, which are hard to copy. Also, note that your email address can also be accessed by the public, if you share Google files. – TheMaster Commented 16 hours ago

1 Answer 1

Use query(), like this:

=query( 
  Form_Responses1[#ALL], 
  "select G, count(G) 
   where K >= date " & text(B2, "'yyyy-MM-dd'") & "
   and K <= date " & text(B3, "'yyyy-MM-dd'") & " 
   and G is not null 
   group by G", 
  1 
)

See query().