Hi
try:
=SUM('H:\Sales Reports for 2005\[Personal Lines Sales Report 2005.xls]2005
YTD TOTALS'!$B2,'H:\Sales Reports for 2005\[Mark Lacher Sales Report
2005.xls]2005 YTD TOTALS'!$B2,'H:\Sales Reports for 2005\[Maura Derstein
Sales Report 2005.xls]2005 YTD TOTALS'!$B2,'[Mark Derstine Sales Report
2005.xls]2005 YTD TOTALS'!$B2)

--
Regards
Frank Kabel
Frankfurt, Germany

ksr wrote:
I can not get my auto fill to work. I will give you example of my
formula =SUM('H:\Sales Reports for 2005\[Personal Lines Sales Report
2005.xls]2005 YTD TOTALS'!$B$2,'H:\Sales Reports for 2005\[Mark
Lacher Sales Report 2005.xls]2005 YTD TOTALS'!$B$2,'H:\Sales Reports
for 2005\[Maura Derstein Sales Report 2005.xls]2005 YTD
TOTALS'!$B$2,'[Mark Derstine Sales Report 2005.xls]2005 YTD
TOTALS'!$B$2) -- I would like to drag this formuala down a column and
have the Cell to increase by one for example:
=SUM('H:\Sales Reports for 2005\[Mark Lacher Sales Report
2005.xls]2005 YTD TOTALS'!$B$3,'H:\Sales Reports for 2005\[Personal
Lines Sales Report 2005.xls]2005 YTD TOTALS'!$B$3,'H:\Sales Reports
for 2005\[Maura Derstein Sales Report 2005.xls]2005 YTD
TOTALS'!$B$3,'[Mark Derstine Sales Report 2005.xls]2005 YTD
TOTALS'!$B$3)
I don't know why it it notting adding the one.
Thank you
karenr