Ask Your Question

Revision history [back]

If you want to sum column A, enter =SUM(A:A).

If you want to sum a whole column, e.g. column A, enter =SUM(A:A). If you want to divide the sum of column J by column G subtracted by column H, enter =SUM(J:J)/(SUM(G:G)-SUM(H:H)).