Countif in non-consecutive cells
=SUMPRODUCT((MOD(ROW(C1:Z13),2)=1)*(C1:Z13=1))
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"michaelberrier" wrote in message
oups.com...
How can I do a countif in non-consecutive cells over a series of rows,
like evens and odds?. I tried this:
=COUNTIF($C$1:$Z$1:$C$3:$Z$3:$C$5:$Z$5:$C$7:$Z$7:$ C$9:$Z$9:$C$11:$Z$11:$C$13
:$Z$13,"1")
but it counts everything on the even rows as well.
Thanks to all.
|