How do you use countif for values in every four cell in a row
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.
|