View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
thatsall
 
Posts: n/a
Default Help me with formula


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.


--
thatsall
------------------------------------------------------------------------
thatsall's Profile: http://www.excelforum.com/member.php...o&userid=30089
View this thread: http://www.excelforum.com/showthread...hreadid=497730