Hello,

I’m trying to count the “0” characters in a column.

In this column the formula can answer “0”, “1” or “2”.

The are some merged cells between some of the regular ones. They are filed with text (no “0” characters here)

Here is my formula :

=NB.SI(K9:K186;“0”)

**BUT**

It counts the fused ones as “0”. I verified, there are 102 “0” cells but it says 107, as if the fused title cells between the other ones contained “0”.

Why ?