Equation help. simple for regular user probably

  • Thread starter Thread starter thatsall
  • Start date Start date
T

thatsall

I have a basic graph 1,2,3,4,5.....going down in and a,b,c,d,e,f,c going
across.

EX.

A B C D E F G
----------------------------------------------
1 500 25 75 800 (200)
2
3
4
5
6
7




My question is how can I make an equation that Goes like this :

Column A+B+D-E=G

I showed an example above for on row but i wouuld wnat this to work for
any row no matter what data I answer.
I want this ewuation to work for any data entered for the whole sheet.
I hope you understand and can help anyone. any ?'s post
 
=SUM(A1:D65536)-Sum(E1:E65536) This will total all the values put int
columns A through D subtracting E.

If you want individual row totals then =Sum(A1:D1)-E1 and copy / past
it down the length of your data.

Hope it helps
 
where do i enter "=sum" into the function bar? and also how do i get i
to end up in the G colum
 
Click in cell G2 (as an example row - adjust the 2 to suit your data).
Type the following:

= SUM(A2:D2) - E2

again, adjusting the 2 here to suit your data. Then press <enter> or
click to another cell.

You can click on G2 again, then click <copy>, then select (for example)
the range G3 to G10, then click <paste> or just <enter>

Hope this helps.

Pete
 
thatsall said:
I have a basic graph 1,2,3,4,5.....going down in and a,b,c,d,e,f,c going
across.

EX.

A B C D E F G
----------------------------------------------
1 500 25 75 800 (200)
2
3
4
5
6
7




My question is how can I make an equation that Goes like this :

Column A+B+D-E=G

I showed an example above for on row but i wouuld wnat this to work for
any row no matter what data I answer.
I want this ewuation to work for any data entered for the whole sheet.
I hope you understand and can help anyone. any ?'s post
Click to expand...
To do exactly what you asked, first put this formula in cell G1:
=A1+B1+D1-E1

Then copy the formula down column G as far as necessary -- to row 65536
if you really want to use all the rows.

I assume you are leaving columns C and F empty or at least not putting
numbers there.

Bill
 
Back
Top