Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default One Formula Referenced In Many Cells

Hi Alsaeh,
in C1 enter

=A1+B1

then copy formulas down

If you want to have a total of column C at the bottom enter

=sum(C1:C1000)

change range to fit your needs

"alsaleh" wrote:

Ed,
I want to sum cells in Col A + cells in Col B, then store the result
in cells of Col C, respectively.
So, A1+B1=C1
A2+B2=C2
'
'
'
'
'
The way I wish to do it is to store a single formula in any place (May
be in C1) then have it automatically sum any numbers in A2, add it to
B2, store the result in C2.
.

Reply
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
referenced cells Michaeld Excel Discussion (Misc queries) 2 June 16th 08 09:02 PM
When I edit the cells referenced in my formula, the result does ch Trav Excel Worksheet Functions 1 January 5th 07 03:47 PM
Ignore Text in Cells Referenced in a formula Steve Excel Discussion (Misc queries) 4 October 19th 06 10:08 PM
Cells referenced in formula bar not highlighted in worksheet squall Excel Discussion (Misc queries) 1 October 5th 06 11:10 PM
Click in cell w/ formula and get colors in referenced cells albean Excel Discussion (Misc queries) 0 November 11th 05 07:04 PM


All times are GMT +1. The time now is 02:46 AM.

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"