0

https://docs.google.com/spreadsheets/d/e/2PACX-1vSac8-YOPZUih1gKI3uTHbfJpIew3QwQ6ccM0Od7lF-E4eLyb-y2adRsrJ9JpyDulkbsMbhIt-qwXaJ/pubhtml

Link to an example.

On the total tab, I have:

=QUERY(data!1:963, "SELECT COUNT(B), SUM(C), SUM(D) where G > date '"&TEXT(F2,"yyyy-mm-dd")&"' and G <= date '"&TEXT(G2,"yyyy-mm-dd")&"'", 1)

However, I want to only count the unique items in B that fall between the date range selected. I Tried to use COUNT(DISTINCT B) but google sheets doesn't seem to like that.

New contributor
Jordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1
  • Hi and welcome to WebApps. Your spreadsheet requires permission to access it. Would you please share a spreadsheet url where anyone with the URL can access the spreadsheet.
    – Tedinoz
    Jan 14 at 9:42

Your Answer

Jordan is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.