| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif in non-consecutive cells
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Errors in COUNT, COUNTA, COUNTIF when counting merged cells | Excel Worksheet Functions | |||
| How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
| How do I set up a formula to repeat 5 consecutive cells in a colum | Excel Worksheet Functions | |||
| How do I set up a formula to repeat 5 consecutive cells in a colum | Excel Worksheet Functions | |||
Threaded Mode
