Count if - cell color index & cell value (range of value)

[PENGUIN88]

Hi Guys,

I have an spreadsheet that presents the unloading of the vechicles on the unloading doors.
I need to have the formula/macro line that shows live' doors stats.

Basicilaly there are two ranges of the unloading doors: 1st- doors from 301 to 329, 2nd - doors from 201 to 227.
Whatever is on the doors is highlighted yellow and have an remark with the doors number, for eg. 315.
There are other colors used for: parking bay, unloaded, awaiting driver etc. We only focus on yellow please.

Now I need the excel to show me the number of the yellow lines that have range from 301 - 329 and another range of 201 - 227.
Both lot of data to indicate how many vechicles is currently on the 200's doors and how many vechicles is currently on the 300's doors.
I hope I have explained this fine and you can get the idea of what I actually need.

Please see attached EXAMPLE simple form to show visualy.
*Please note there is an about 90 rows like this and these change houndreds times during the hour.*

[humdingaling]

using UDF and helper column