ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   formula... PLEASE HELP (https://www.excelbanter.com/new-users-excel/24505-formula-please-help.html)

Roelamp

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

Peo Sjoblom

=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



Roelamp

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