Solved

# Excel 2007 - How to copy the sum of two two amounts?

Posted on 2011-02-11
226 Views

Cell a + cell b = Cell C.

I cant ctrl C or right click and copy.
Is there a way?
Thanks

0
Question by:fcek

LVL 24

Expert Comment

ID: 34871780
Use a formula? Don't think you can copy two cells and paste the sum (without VBA anyway).
0

LVL 50

Expert Comment

ID: 34871790
Do you just want this in C2

=SUM(A2,B2)

regards, barry
0

Expert Comment

ID: 34871812
There's no shortcut to perform this action via keyboard or mouse click.  You have to do this via a formula:
in Cell C1 enter "=A1+B1"  or "=CONCATENATE(A1,B1)"
0

LVL 6

Accepted Solution

Let's Go earned 500 total points
ID: 34885402
If you use barryhoudini's formula in cell C2, you can then

copy the sum (ctrl-c)
paste as a value (instead of a formula) it using paste special/values (available by right-clicking, or from the ribbon Home/Clipboard.
0

Author Closing Comment

ID: 34890981
ctrl and c

right click paste special > value

done
0

## Featured Post

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…