Need macro/formula to count inconsistent ranges of data

Hello,

I have a tasks that takes a lot of manual work and counting. I believe a formula or macro could be use in this case. Attaching the file.
So main task is to count how many items is in one sequential range. Main data sheet - is what i have, and Ranges count data - how i need it to look.
Range is going in sequential order, and sometimes it has a gap, and restarts range from there. I need to know how many items is from the beginning until the gap, and then again from the one gap until other. I am not sure i can explain it very good, hopefully excel file will give you an idea what is needed. Usually i have 200+ lines of these ranges.

thank you very much!!!

Format your source data as a table, then use Power Query:

Please Login or Register  to view this content.

Sure - use this:

Please Login or Register  to view this content.