I would like to get totals on the bottom of a table created with a query function. I have managed to total one column but when I try and get a total for the next column it displays the total 1 cell below. I also have issues with 'array string literals'. If someone could explain these to me and how to avoid that error it would be greatly appreciated. Here is my formula.

={QUERY('Account Review Tracker'!$A$2:$S$499,"SELECT A, B, C, H, P, L, N where (H='Yes' AND A>date '2021-09-12')",1); {"Total","","", Query('Account Review Tracker'!$A$2:$S$499, "select Count(H) where (H='Yes' AND A>date '2021-09-12') label count(H) ''",""),"","",""; {"","","","", Query('Account Review Tracker'!$A$2:$S$499, "select Count(P) where (P='Yes' AND A>date '2021-09-12') label count(P) ''",""),"",""}}}

  • Please add a brief description of your search efforts as is suggested in How to Ask.
    – Rubén
    Sep 20 at 16:31
  • 1
    I would also suggest that you share a copy of your sheet. As it stands, we have no idea what kind of data is in each of the return columns (e.g., are they all numerical? some text and some numerical?). What seems completely clear to you is vague at best for those of us "out here" when we can't see what you see and don't know what you know.
    – Erik Tyler
    Sep 20 at 19:22

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.