View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default CountIf in Even Rows only

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