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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |