I have a sheet with bank statements and a want to set up a summary sheet with the total amounts per client.

I know how to do that from within the statements sheet, e.g. summing up client A:


enter image description here

But how can I do it directly from the summary sheet? Is there a way?


how can I do it directly from the summary sheet?

Your summary sheet is just another tab

=SUMIF('summary sheet'!A31:B41,"A",'summary sheet'!B31:B41)

Your summary sheet is a different spreadsheet altogether
Neither SUMIF nor SUMIFS work well when referring to a different spreadsheet.

In this case you should use a combination of the QUERY function and the IMPORTRANGE

=QUERY(IMPORTRANGE("xxxxxx","'summary sheet'!A31:B41"),"select Sum(Col2) where Col1='A' LABEL Sum(Col2) '' ")  

(please adjust ranges to your needs)

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. – marikamitsos Jul 27 '20 at 13:37
  • Thank you, this worked. I should have mentioned that it is another tab – QQ-88 Jul 27 '20 at 14:03
  • Glad I could help. Thank you for taking the time to accept. – marikamitsos Jul 27 '20 at 14:28

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.