Hello,
I am trying to run different, simple formulas in different cells and I was wondering if there was any easier way to do this than to type out the formula each time.
Here's what I'm trying to do:
A| B| C| D
3| 4| 2| =sum(a1:b1:c1)
12| 111| 9| =sum(a2:b2:c2)
etc...
As you can see, the formulas in column D are very similar, with only the row number changing. Is there any quicker way to do this other than writing out =sum(...) in every D cell?
This may give you a better understanding:
http://i230.photobucket.com/albums/e...untitled-3.jpg
Last edited by infernusx0; 10-26-2011 at 04:07 PM.
Do =SUM(A1:C1) then Control + enter then D1 has a box around it put your cursor over the right bottom corner till it turns into a plus sign then double click.
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
You sir, are fuccccking brilliant.Originally Posted by khamilton
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks