#1
|
|||
|
|||
Using (adding) different cells
I wish to add two cells together, from different sheets (i.e. Sheet 1 H12 + Sheet 2 K34) into say cell K40 on sheet 2.
Appreciate any help on this Geoff |
#2
|
||||
|
||||
Enter = in your result cell
Click H12 in sheet 1 Enter a + in the formula bar Click the second cell (K34) Press enter |
#3
|
|||
|
|||
Thank you Pecoflyer, I had managed before on another PC but just had a mental block ...... did sort it in the end, through trial and error this morning.
Thanks anyway for your reply |
#4
|
||||
|
||||
You're welcome
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I mirror cells? | shabbaranks | Excel | 2 | 09-13-2011 04:58 AM |
Adding Image into a excel cell and adding a hyperlink to the image | saravananiyyanar | Excel | 3 | 05-04-2011 08:31 AM |
How to Count from Different Cells? | Shahzad | Excel | 3 | 06-26-2010 01:06 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Display the cells which add up to a certain sum | edbyford | Excel | 1 | 11-26-2009 01:30 PM |