Feb 06 2018
12:29 AM
- last edited on
Jul 25 2018
10:58 AM
by
TechCommunityAP
Feb 06 2018
12:29 AM
- last edited on
Jul 25 2018
10:58 AM
by
TechCommunityAP
Hi, I'm wondering if there is a function/formula that I can apply to an entire column that will add entities on a row by row basis. I want my cells in column Q, Q5 for example, to give me the sum of N5-O5-P5. I can apply a sum formula for Q5, Q6, Q7, etc. individually, but I would like to know if I can save time by applying a function to the entire column to do this?
The image shows the spreadsheet for clarification.
Thanks
Feb 06 2018 12:58 AM
Kevin,
here is one way to do it:
=SUM(N:N)-SUM(O:O)-SUM(P:P)
Feb 06 2018 01:04 AM
Feb 06 2018 02:35 AM
Kevin,
I misunderstood your issue.
Then it is simply:
=N5-O5-P5
And copy the formula down.
Feb 06 2018 04:28 AM - edited Feb 06 2018 04:34 AM
Hi, Kevin. I am not sure your question. Your original message said you have done with Sum formula. You can copy and paste in the whole Column Q.
Just in case, perhaps you used something like
=SUM($N$5:$P$5)
In the above formula, the reference address is an absolute reference address. Wherever you copy and paste that formula (except N5 to P5), it gives the same result becuase it refers to the same 3 cells.
You can use relative reference address in Q5 like
=SUM(N5:P5)
If you copy it and paste in Q6, the formula will change to
=SUM(N6:P6)
or copy it and paste to D1, the formula will change to
=SUM(A1:C1)
You may read Switch between relative, absolute, and mixed references for more infomation.
In addition, you may use Fill Handle to fill the formula for you if you use relative reference address for the formula.
Feb 06 2018 07:41 AM