not sure what you are trying to accomplish with the formula.

As posted, the formula would count numeric 0 in the range of columns where
the mod = CG9.

The -COLUMN($B13)+0 stuff makes it robust against column insertions but
the +0 is not needed.

So, it all depends on what's in CG9 as to which columns are calculated.

LOL... I have to learn to read better... I just went back to re-read the
original post again (mainly because you answered it once and seemed still
not to be as puzzled in your response to me as I was in my initial
reading)... I totally overlooked the "W" in the "BW" references and read
every range as $B13; so I couldn't understand why the OP was using a
SUMPRODUCT on a single cell instead of a range. I look at it now and the W's
are clear as can be; but I would swear they weren't there when I first read
(and re-read) the original posting... weird.

Rick