Count total from a cell in multiple sheets & files

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
How do I create a formula that will count the total from G1022 in each sheet of the Trending3a and Trending3b file and place the result in D4, of the "Info" sheet in the Backend file.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Joined
Jul 30, 2006
Messages
3,656
This should get you started.

Adjust the below formula according to 1 thru 4:

1. adjust the ????? with the correct foldername(s)
2. adjust the filename with the correct file name
3. adjust the Sheet1 name withe the correct sheet name
4. adjust the cell address $A$1 with the correct address from filename

='C:\Documents and Settings\?????\My Documents\?????\[filename.xls]Sheet1'!$A$1

Copy the adjusted formula into cell D4, in the 'Info' sheet, in the Backend file:
='C:\Documents and Settings\?????\My Documents\?????\[Trending3a.xls]Sheet1'!$G$1022


I am using Windows XP Professional SP2, and Excel 2003 SP2.

Have a great day,
Stan
 

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
Emergency Help Please, someone!
I entered the following formula:
='C:\Documents and Settings\?????\My Documents\?????\[Trending3a.xls]Sheet1'!$G$1022
then got Mircosoft Excel error report, I selected ok to send report, then it opened excel and started repairing several important files, while deleting some original settings. I deleted the recovery and repaired files, checked for my original files on my hard drive directory and they are apparently deleted. How do I recovery these files. Isnt there a way to do a total recovery of files through a system backup. I am running win xp 2002
 
Joined
Jul 30, 2006
Messages
3,656
Brew,

You did not follow the instructions:

Adjust the below formula according to 1 thru 4:

1. adjust the ????? with the correct foldername(s)
2. adjust the filename with the correct file name
3. adjust the Sheet1 name withe the correct sheet name
4. adjust the cell address $A$1 with the correct address from filename


Have a great day,
Stan
 

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
I did not have the opportunity to complete the instructions, I just copied the original formula into the backend file, to update it according to the instructions given and then everything I explained in the previous post occurred!
Is there anyone that can explain how to do a system recovery of files?
 

Forum statistics

Threads
1,136,261
Messages
5,674,705
Members
419,520
Latest member
Jennifer4Dillon

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