Using data from another sheet in Google Spreadsheet

Question

I'm trying to write a SUM function in sheet B, summing all the data from sheet A in specific rows. I can't find a good explanation of how to do this.

Please vote for the answer if it helped you. – MetaEd Dec 6 '11 at 17:14 — MetaEd, Dec 6 '11 at 17:14

Jacob Jan Tuinstra · Accepted Answer · 2013-10-29 21:19:27Z

1

If you want to "retrieve" specific rows, then you need to use the following formula.

Formula

=SUMIF(range, criteria, sum_range)
=SUMIF(DATA!A:A,"<="&10,DATA!A:A)

In this case, the specific rows are summed , only if the value is smaller or equal to 10.

I've created an example file for you: SUMIF

answered Oct 29 '13 at 21:19

21.1k15 gold badges87 silver badges182 bronze badges

Add a comment |

Geoff · Accepted Answer · 2011-10-20 15:46:36Z

8

Try the solution on this page, i.e.:

=sum(Sheet1!D7:D8)

answered Oct 20 '11 at 15:46

Geoff

1813 bronze badges

Add a comment |