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.
-
3Please vote for the answer if it helped you.– MetaEdDec 6, 2011 at 17:14
2 Answers
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