Posted to microsoft.public.excel.worksheet.functions

Rick Rothstein Rick Rothstein is offline

external usenet poster

Posts: 5,934

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif on 2 different rows	kd5000	Excel Discussion (Misc queries)	2	October 26th 07 09:18 PM
Countif on 2 different rows	kd5000	Excel Discussion (Misc queries)	1	October 26th 07 09:10 PM
COUNTIF in between rows	Vasilis Tergen	Excel Worksheet Functions	20	January 13th 07 10:22 PM
Countif rows	Lauravila	Excel Discussion (Misc queries)	2	December 20th 06 04:05 AM
Using COUNTIF with visible rows only	Dr Happy	Excel Worksheet Functions	2	December 7th 05 03:45 PM

All times are GMT +1. The time now is 08:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us