Hi,

You should be able to modift this for all your L numbers

="L31 = "&COUNTIF(C5:C123,"L31")

and for the blanks

="Blanks = "&COUNTBLANK(C5:C123)

Mike



"PhilH" wrote:

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?