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


Cell a + cell b = Cell C.

I cant ctrl C or right click and copy.
Is there a way?
Thanks
 
fcekAsked:
Who is Participating?
 
Let's GoConnect With a Mentor Commented:
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
 
StephenJRCommented:
Use a formula? Don't think you can copy two cells and paste the sum (without VBA anyway).
0
 
barry houdiniCommented:
Do you just want this in C2

=SUM(A2,B2)

regards, barry
0
 
kostyakCommented:
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
 
fcekAuthor Commented:
ctrl and c

right click paste special > value

done
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.