LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Excel Circular Reference SUM HELP!

Hi all, I'm fairly new with Excel so let's see if I can get a quick answer
for my question :).

I am trying to add a base number to whatever number i Input within the same
cell. For example: The Cell I am working with is I4. The base number I want
is 3500. I want that added to whatever I type in the cell and summed in the
same cell. So if I type in 2200, the sum would be 5700. =SUM(3500,I4) does
not work. I get a 0 in the cell and if I try to input 2200, the formula just
erases. I need this formula for alot of cells all with the base number of
3500 and random input numbers. This IS possible isn't it?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circular Reference build Excel Worksheet Functions 1 October 19th 07 01:08 PM
Is this possible? (Circular reference?) Big UT Fan Excel Discussion (Misc queries) 2 July 11th 07 04:48 PM
Issues with my excel formula as it needs Circular reference - hlp im_not_excelling Excel Worksheet Functions 1 July 4th 06 08:21 AM
Circular Reference Saintsman Excel Worksheet Functions 5 June 5th 06 06:39 PM
circular reference (Excel 2000) peaspud Excel Worksheet Functions 6 November 21st 05 06:16 PM


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"