G Sheet - Sumifs for data from another sheet

Question

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:

=SUMIF(B1:B,A1:A,"A")

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

marikamitsos · Accepted Answer · 2020-07-27 13:36:58Z

0

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)

answered Jul 27 '20 at 13:36

marikamitsos

9,8123 gold badges20 silver badges46 bronze badges

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

Add a comment |

1 Answer 1