working with data from two sheets

weatherless

New Member
Joined
Feb 24, 2004
Messages
1
Hi,

I have two spreadsheets, approx. 20 X 10 each, and I want to subtract corresponding cell values and put the new value in a summary sheet. For examp., cell A1 in SheetA has a value of 25 and cell A1 in Sheet B has a value of 15, and I want to get the difference of these two, and put the value into cell A1 of the summary SheetC. How can I create a formula that gives the difference for corresponding cells and puts them in a new sheet?

Thanks!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

In Sheet 3 A1, put =Sheet1!A1-Sheet2!A1. Copy across the applicible range.

Hope that helps,

Smitty
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,102
Members
425,454
Latest member
khoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top