Timeline for Google Sheets - Sum formula that relates with one row to another
Current License: CC BY-SA 3.0
4 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jan 19, 2017 at 2:39 | comment | added | Karl_S |
@ben You would then use SUMIFS() which allows for multiple criteria: =SUMIF( $B$11:$B, $A$11:$A, "=Kinder", $A$11:$A, "=1st") and you can add additional criteria pairs to the end
|
|
Jan 18, 2017 at 23:13 | comment | added | ben | Awesome, I love this. What if I want to calculate the sum for Kinders and 1st graders? | |
Jan 18, 2017 at 22:43 | comment | added | STowslee | This is pretty handy for use in areas where pivot tables aren't an appropriate solution. | |
Jan 18, 2017 at 20:14 | history | answered | Karl_S | CC BY-SA 3.0 |