using number of sheets in a formula

F

Fawn

I have a workbook with several sheets that roll up to a YTD. What I want to
do is to have one of the columns multiply by the number of sheets in between
the start and end sheets.

For example


Weekly target is YTD

3300 YTD will be 3300 *(# of sheets)


Is this possible


Any help would be appreciated

Thanks
 
Top