=COUNTIF((x12):(z12):(m12),3)

Adding the parethesis and colons make them individual cells and not a range.

"Carmit" wrote:

i try to add formula of "count if". the range is not from cell x to cell y,
but it is cell x, cell z & cell M, which are not sequential.