How do you use countif for values in every four cell in a row
Thanks alot Guys, It works great, Better than stringing COUNTIFs 27 times
to get one answer. Thanks again.
One Happy Customer
"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
|