I need to set each cell in a column to sum two cells on its row. Such that each cell in column d is the sum of specific cells in its row.
it is a long list and I would like to not type make the equation for every cell.
Please Login or Register to view this content.
Last edited by shg; 12-28-2011 at 06:57 PM.
In D1, enter =a1+c1 and copy down. The formula will adjust.
Entia non sunt multiplicanda sine necessitate
Hello and welcome to the forum,
Maybe
In D1: =A1+C1
In D2: =A2+C2
In D3: =A3+C3
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Other option would be to put
=SUM(A1,C1)
in D1 and drag down as shg as suggested.
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks