excel date divisor

[kenpcli]

If I have a workbook and the first worksheet is the main worksheet that sums other worksheets, how do i get the divisor number to change each time I add a new worksheet. For examble in january the main sheet would divide each row by 1, but when I add a new worksheet for february, it would automatically change the divisor to 2 and so forth.

Thanks

 

[mrhstn]

Hi

Which version of Excel do you have? Does the workbook contain only the main sheet plus a sheet per month or are there other sheets?

 

[kenpcli]

Hi

Which version of Excel do you have? Does the workbook contain only the main sheet plus a sheet per month or are there other sheets?

2016, Just main and a worksheet for each month.

 

[mrhstn]

That being the case you could use

=SHEETS()-1

Which will return the total number of sheets in the workbook and subtract one for the main sheet.

 

[kenpcli]

That being the case you could use

=SHEETS()-1

Which will return the total number of sheets in the workbook and subtract one for the main sheet.

Thank you

 

[mrhstn]

You're most welcome.