Wow, that's Great!

Thanks a lot.

One thing that confuses me, in countifs why you put another criteria range in criteria1. We should put only a criteria there not a range, right?

Could please explain how that is working.