Elegant Solution to summarise progress information

Hi,

I have a dataset in the attached format.
I am looking for an elegant and dynamic solution to obtain the summary information in cells N1:N9.


I have to prepare the same sheet for a lot of buildings with different no.s of basements and floors, so the process is tiring.

Thanks in advance.