For the national counts:
In column AB, starting in AB2 list the possible floor numbers,ie;12 to 105.

In Column AC2 place this formula 
=SUMIF(C:C,AB2,Z:Z)
Copy it down to the bottom of the list of floor numbers

I don't understand the problem with state counts, you already have those results in column AB