Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto fill of formula
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Auto fill box | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Formula Fill properties | Excel Worksheet Functions |