counting protected cells in a range of cells

sandeepvr 

That syntax is not valid, but unfortunately, the CELL function does not return an array, just a single value if you specify  a multi-cell range.

You might create the VBA function listed below in a module in the Visual Basic Editor. Don't forget to save the workbook as a macro-enabled workbook (.xlsm) and to allow macros when you open it.

Function CountLocked(rng As Range) As Long
    Dim cel As Range
    For Each cel In rng
        CountLocked = CountLocked - cel.Locked
    Next cel
End Function

Use like this:

=CountLocked(A1:A10)