Google Sheets – SUM of All Cells in Another Column Except Above Rows

google sheets

Each cell in column A should report SUM of every cell of column B, except rows above those cells.

Sample:

| A | B |
---------
| 4 | 1 |
| 3 | 0 |
| 3 | 1 |
| 2 | 1 |
| 1 | 1 |
| 0 | 0 |

How can I achieve this using Google Spreadsheets?

This is almost the same as a cummulative sum, but reversed.

Formula

=SUM(B2:$B$7)

=ARRAYFORMULA(SUMIF(ROW(A2:A7);">="&ROW(A2:A7);B2:B7))

If you add the first formula in C2, then you're able to copy that cell (drag) to C7. The ARRAYFORMULA will present the result at once.

I've created an example file for you: Inverse Cummulative Sum

=SUMIF(D:D,"bob",C:C)

in C column are numbers, in D column are ("bob" or others)

if you wish do not sum all column you can use for example

=SUMIF(D2:D6,"bob",C2:C6)

Note: Text is case sensitive (Bob is not equal bob)

Try:

=ArrayFormula(if(len(H2:H)*len(G2:G), iferror(H2:H/G2:G, 0),))

The formula will output results if there are entries in col H AND col G. See if that works for you ?