We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

=SUM(J23/(G23-H23)) for a whole column?

asked 2018-07-13 18:09:07 +0200

joe09876 gravatar image

updated 2021-05-28 17:35:05 +0200

Alex Kemp gravatar image

Can I perform this SUM for a whole column without entering in each line number manually? Is there a simpler way to do it if not?


I would like to have a fourth column that has the value of the formula for each line (e.g. K23 would be the result of the above formula).

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-07-13 18:26:44 +0200

hjek gravatar image

updated 2018-07-13 18:29:55 +0200

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)).

edit flag offensive delete link more

answered 2018-07-17 23:22:15 +0200

updated 2018-07-17 23:53:16 +0200

Depending on what is meant by "for a whole column", @hjek's answer may apply; or, as I suspect (based by your "I would like to have a fourth column that has the value of the formula for each line"), you could mean simply how to copy the formula to all cells in a column.

Then, you can enter the formula to, say, K23 (as you show); then copy the cell (not the text in cell!) - single-click to another cell first, then single-click back to K23, making sure that you are not editing the formula, then Ctrl+C; then select all the cells in the column (or - preferrable - a subrange adjacent to your data) - by clicking with mouse on the column's header, or by putting cursor to last cell and using Shift+Ctrl+, or by entering the range (K:K or K1:K123) into Calc's Name Box at top left corner of the sheet; then paste: Ctrl+V.

By the way: the formula =SUM(J23/(G23-H23)) is equal to this simplified formula: =J23/(G23-H23).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-13 18:09:07 +0200

Seen: 200 times

Last updated: Jul 17 '18