Skip to main content
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