Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple non-consecutive rows
How do I include multiple non-consecutive rows in a COUNTIF function. I need
to check rows (4,7,10,13 thru 97 (every third row)) for a value. I used = COUNTIF (4:4, "Yes") and it returns the correct number. I have tried several methods to include the 32 row I need to check for the value "Yes" and it will not allow the multiple rows Thanks in advance. -- RW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
min function on non consecutive rows | Excel Worksheet Functions | |||
copy non-consecutive rows | Excel Discussion (Misc queries) | |||
PULLING OUT CONSECUTIVE ROWS | Excel Discussion (Misc queries) | |||
Inserting multiple non-consecutive rows | Excel Discussion (Misc queries) | |||
Select non-consecutive rows | Excel Discussion (Misc queries) |