Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excell functions howto
Name: mitra Date: April 16, 2003 at 11:20:34 Pacific OS: win xp CPU/Ram: enough
Comment:
Hello I am new to excell office tool. I fill two columns (A2:A50 and B2:B50) with some numbers. now I want the sum of these 2 column be in C (I mean Ci = Ai + Bi for 2=i=50). I know how to write a function only for a cell (e.g =SUM(A2,B2)) but I don't want to fill all 49 cells by hand. I don't know what to do plz help me stp by stp. thanx in advance
Name: seawatch Date: April 16, 2003 at 11:55:14 Pacific
Reply:
=SUM(A2:A50,B2:B50)
This will sum any numbers you put in any cells between A2 and B50.
Place the formula in a cell in column C in blank sheet and put two or three numbers in any cells in A and B (between 2 and 50 of course)and see if it does what you want.
Larry
0
Response Number 2
Name: A Certain TH Date: April 17, 2003 at 05:17:29 Pacific
Reply:
Mitra
You can use the AutoFill tool for this. Select the cell with your formula, ie cell C2. Then point the mouse cursor at the bottom right corner of the cell - it will turn into a little black cross. When this happens, click and drag down to "autofill" the range you select. (you can just double-click if the data in column B is continuous)
Look in the help file for much much much more on the subject of AutoFill - it is hugely important to your understanding of Excel!
Cheers Tom
0
Response Number 3
Name: seawatch Date: April 17, 2003 at 13:59:13 Pacific
Reply:
Auto fill is great but it won't give him the some of two columns in column c.
Unless he meas A1 + B2 with answer in C2, in which case your autofill trick is absolutely the best way to do that.
Larry
0
Response Number 4
Name: A Certain TH Date: April 22, 2003 at 01:18:17 Pacific
Reply:
I presumed thats what was meant by (I mean Ci = Ai + Bi for 2=i=50).
Apologies if not
Tom
0
Response Number 5
Name: seawatch Date: April 22, 2003 at 03:52:48 Pacific
Reply:
Yeah, I was a little confused also. Well now he can do it either way.
Larry
0
Response Number 6
Name: mitra Date: April 23, 2003 at 09:04:31 Pacific
Summary: Is there a excel function that I can use to solve my problem? Help! In sheet 1 I have the follow data: Line No Amount MaturityDate 790 500 12/31/10 790 350 10/8/...
Summary: Im sure this is really simple. Basically I am trying to make a simple function to create bin labels, instead of having to manually typing them in. Basically, I start at A1A1,A1A2,A1B1,A1B2,...A1D2. I ...
Summary: I need help with the vlookup functions in excel. Let's say I have two tabs, the second tab is a pivot table based on the first tab. I want to build a vlookup function (probably need two in the same fo...
0 
