Hi all.
Please help me with the formula for below :

My workbook has multiple worksheets.

1st worksheet is named = bkg details.
3rd worksheet is named = contr track.

In 1st worksheet, i have booking no. ( ebkg01959735 ).
In 3rd worksheet i have data pertaining to the containers picked up against this booking # ebkg01959735.

This booking is for 10 containers.
So i have copied this booking no ( ebkg01959735 ) in 10 rows.... 1 container per row ( c55 to c64 ) - in worksheet 3.
As soon as one container is picked up, i fill the date in column "o" in worksheet 3.
If 10 containers are picked up, i will have dates from o55 to o64.... Against this booking no. Ebkg01959735.

Now in worksheet 1 ( bkg details ), in column n25, i need the count of no. Of containers picked up against this booking from worksheet 3.
If 5 containers are picked up, i need this count to show 5 in worksheet 1.

Column "o" in worksheet 3 is a date field ( 12-oct-21 ).
Column "c" in worksheet 3 is a text field. ( ebkg01959735 ).

Appreciate if someone can sort this out asap please.
Gratitude !!!

Regards.
Kiran