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.

  • 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

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.