In the range C5:C123, I want to count the number of times L31, L311, L316,
and L318, and blanks appear, and have the information appear like this:

L31 14
L311 24
L316 45
L318 33
Blank 3
Sum 119 (the total number of cells in the range)

How would this be done?