Like a placeholder. If it's needed to start counting/summing, etc. from
the first Nth value/cell, just change to +1.

Biff wrote:
-COLUMN(C4)+0


What's the +0 for?

Biff

"Aladin Akyurek" wrote in message
...

When columns are inserted before the data, calculations will be
incorrect...

=SUMPRODUCT(--(MOD(COLUMN(C4:S4)-COLUMN(C4)+0,4)=0),--(ISNUMBER(C4:S4)),--(C4:S4=0))

is robust against such insertions.

Biff wrote:

Hi!

Try this:

=SUMPRODUCT(--(MOD(COLUMN(C4:S4)+1,4)=0),--(ISNUMBER(C4:S4)),--(C4:S4=0))

Biff

"Ring eye" wrote in message
...


How do you use COUNTIF to check certain cells in a row that have a value
of
zero.
cell C4, cell G4, cell K4, cell O4, cell S4, ....etc




--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.