counting distinct values within different sub-ranges

Hi Community,

This is my first post, I hope you will be able to help me

I am trying to do 2 counts. Firstly, a count of the number of devices that are being used in each ward of the hospital.

Secondly, a count of the number of patients in each ward in the hospital.

I have attached sample data with the manually calculated results.

Many thanks
Leeroy