![]() |
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 |
=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 |
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 |
All times are GMT +1. The time now is 01:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com