|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 16th, 2005, 12:57 PM
|
|||
|
|||
Formula help
I want to sum a cell that contains a formula with another cell that contains
a formula. How do I write a formula that will show the rersult? 
|
|
#2
January 16th, 2005, 03:54 PM
|
|||
|
|||
|
Just add the 2 cells together.
Same as if they contained simple numeric data. =SUM(B2,B4) =B2+B4 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DEEKABEE" wrote in message ... I want to sum a cell that contains a formula with another cell that contains a formula. How do I write a formula that will show the rersult?
|
|
#3
January 16th, 2005, 03:59 PM
|
|||
|
|||
|
If the first cell containing a formula is A1 and the second is A2, one
way: =A1+A2 In article , "DEEKABEE" wrote: I want to sum a cell that contains a formula with another cell that contains a formula. How do I write a formula that will show the rersult?
|
|
#4
January 16th, 2005, 04:01 PM
|
|||
|
|||
|
It should be no different. Assuming your first cell w/ the formula is A1 and
the other B2... Then, in C3, you should be able to use =A1+B2 to get a sum regardless if A1 and B2 are formulas "DEEKABEE" wrote: I want to sum a cell that contains a formula with another cell that contains a formula. How do I write a formula that will show the rersult?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
| Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
| Excel Formula | yuki | Worksheet Functions | 7 | September 28th, 2004 02:40 AM |
| Add to formula | Pat | Worksheet Functions | 16 | September 24th, 2004 03:38 PM |
| Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |
Linear Mode
