| 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 | |||
Threaded Mode
