Google-sheets – Autosum entire column

google sheets

On Google Sheets, I enter my sales for the month in Column F. How can I get column F to Auto Sum so that the total always appears below the bottom entry?

Best Answer

This is not a very elegant solution, but at least it does not require a script.

Enter the formula =IF(F2="","",IF(2*F2=SUM(F$2:F2),"",SUM(F$2:F2))) in the cell F3.
Drag it down throughout the column.
Right now, the column is empty. But if you enter 100 in F2, the number 100 will appear in F3, as the total. If you type 300 in F3, the number 400 will appear in F4. And so forth.

The conditional statements in item 1 ensure that the cell shows the sum of the cells above it only if (a) its neighbor above it is not empty; and (b) the neighbor above is not itself the sum of the previous cells.

Short answer

=ArrayFormula(sum(sumif(A:A,{"Bus";"Train"},B:B)))

Explanation

A:A is the column containing the categories.
{"Bus";"Train"} is a 1x2 array. It could be replaced by a range 1xn arrange containing the categories to be included in the sum.
B:B is the column containing the values to be summed.
sumif returns of the sum of values corresponding to each specified category
sum returns the sum of the returned array by sumif
ArrayFormula :

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

Reference

Google Sheets – Use Two Values from One Column to Fill Another Column

Short answer

=ARRAYFORMULA(IF(F3:F,(F3:F-F2:F),""))

Explanation

Both parameters of a subtraction operation should be arrays in order to return an array.

Best Answer

Related Solutions

Google Sheets Formulas – How to Sum a Column if Another Column Contains Any of the Values

Short answer

Explanation

Reference

Google Sheets – Use Two Values from One Column to Fill Another Column

Short answer

Explanation

Related Topic