=MODE(IF(C1:C8<4,C1:C8))

entered with ctrl + shift & enter will not consider 4

Regards,

Peo Sjoblom

"glasskit" wrote:

I would like to create a function that finds the mode of a range of cells,
but does not consider a particular value in the range.