NEED HELP Numbering Cells Across Worksheets

[th6yuj]

I am using this formula to number items on a sheet. When I add or delete rows the row numbers for each item updates to give the correct count.
=IF(B3600<>"",COUNTA($B$2:B3600),"")

How do I continue the number count to multiple sheets

 

[JLGWhiz]

You would have to add the last sell value of the previous sheet to your CountA result.

Example:

[COLOR=#ff8c00]=IF(B3600<>"",COUNTA($B$2:B3600)+Sheet1!B3600,"")[/COLOR]

 

[th6yuj]

You would have to add the last sell value of the previous sheet to your CountA result.

Example:

[COLOR=#ff8c00]=IF(B3600<>"",COUNTA($B$2:B3600)+Sheet1!B3600,"")[/COLOR]

Thank You

 

[JLGWhiz]

Thank You

You're welcome. And that should be "cell" not "sell".
Regards, JLG