Count sheets between two sheets

Hi,

I have the following nine sheets in my workbook: "Sheet1,Sheet2,Sheet3,Start,Shoot1,Shoot2,Stop,Sheet8,Sheet9"

I want a formula that counts how many sheets there are between sheet "Start" and sheet "Stop". Which is two. Naturally if i drag more sheets in between "Start" and "Stop" the calculated number changes.
I want it to be a formula so that I can divide the number of sheets with a fixed cost I have in the workbook.

Any ideas?

Best regards
Andy

Try this:

=SHEETS(Start:Stop!A1)-2

Amazing - perfect! Thanks

Br Andy

You're welcome. Happy to help.

Thanks for the rep!