CountIf in Even Rows only
Sorry, I forgot about the "even rows" condition. Try it this way...
Over 15
=========
=SUMPRODUCT((MOD(ROW(A:A),2)=0)*(A:A15))
Between 14 and 15
===================
=SUMPRODUCT((MOD(ROW(A:A),2)=0)*(A:A=14)*(A:A<=15 ))
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
Try these...
Over 15: =COUNTIF(A:A,"15")
Between and including 14 and 15: =COUNTIF(A:A,"=14")-COUNTIF(A:A,"15")
--
Rick (MVP - Excel)
"Otto Moehrbach" wrote in message
...
Excel 2007
I want to count the number of cells in a range that, say, are over 15,
but I want to consider only cells in even rows.
Also, I need help with counting cells that are, say, 14 to 15. Thanks for
your time. Otto
|