[program-l] Re: Excell
- From: "Pranav Lal" <pranav.lal@xxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Mar 2009 06:39:02 +0530
Hi Jim,
1. in cell g3, you could have a formula like
=sum(a3:e3)
2. Now, you could put your constant in another cell say j3 so, your formula
then becomes
=sum(a3:e3)-$j$3
3. You now need to copy this formula down the row. To do this, you navigate
to cell g3, press ctrl+c, then hold down the shift key and hit the down
arrow key. This highlights the formula in g3 and then as you move down the
row, selects the other cells where you want this formula copied.
4. When you have reached your last row, you release the shift+down arrow key
and hit ctrl+v.
5. If you need to insert a row in the middle, as far as I know you will need
to adjust the formula manually.
6. The same applies to when you want to place the sum in additional rows.
Note:
I have placed the dollar sign around cell j3 to ensure that the cell
coordinates do not change as you copy the formula down the row.
Pranav
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
