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.

Answer 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)

Explained

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

Example

I've created an example file for you: SUMIF

Answer 2

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

=sum(Sheet1!D7:D8)