| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula... PLEASE HELP
Hi,
I have what I think is a formula...on Sheet 1 I have a total $ amount for items sold. I typed in L3+M2 (the L column is profit and M is the total..NOW..on Sheet 2 I have the same thing for different items, I would like to take sheet 2's M column and add it to sheet 1's. Is this possible? Thank you soooo much. Rosie |
|
#2
|
|||
|
|||
|
=L3+M2+'Sheet2'!M2
as an example -- Regards, Peo Sjoblom "Roelamp" wrote in message ... Hi, I have what I think is a formula...on Sheet 1 I have a total $ amount for items sold. I typed in L3+M2 (the L column is profit and M is the total..NOW..on Sheet 2 I have the same thing for different items, I would like to take sheet 2's M column and add it to sheet 1's. Is this possible? Thank you soooo much. Rosie |
|
#3
|
|||
|
|||
|
THANK YOU :)
"Peo Sjoblom" wrote: =L3+M2+'Sheet2'!M2 as an example -- Regards, Peo Sjoblom "Roelamp" wrote in message ... Hi, I have what I think is a formula...on Sheet 1 I have a total $ amount for items sold. I typed in L3+M2 (the L column is profit and M is the total..NOW..on Sheet 2 I have the same thing for different items, I would like to take sheet 2's M column and add it to sheet 1's. Is this possible? Thank you soooo much. Rosie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| Dynamic (?) formula | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
