Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using countif on non-consecutive cells
How do I use the countif on non-concecutive cells, i.e. I want to know the
number of certain cells in worksheet that contain a specific value. For instance, how many cells in a1:a5, a7, a15:a18 contain the value of 1. -- Marty |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=COUNTIF & how to make it apply to consecutive cells | Excel Worksheet Functions | |||
Countif non consecutive columns | New Users to Excel | |||
Using Countif to Count Consecutive Relative Increases in Numbers | Excel Discussion (Misc queries) | |||
Countif in non-consecutive cells | Excel Discussion (Misc queries) | |||
sumif/countif on non-consecutive colums - array? | Excel Worksheet Functions |