| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif in non adjacent columns
Is it possible to use countif to count the number of times a certain number
appears in column A, C, E...etc through to W, but ignoring columns B, D, F, etc through to X I can only get the countif to work if I use the full range (A1:X1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add adjacent cell value to existing CountIF formula | Excel Worksheet Functions | |||
| Using CountIf with non-adjacent cells in same column | Excel Discussion (Misc queries) | |||
| Countif across multiple non-adjacent cells | Excel Discussion (Misc queries) | |||
| countif = < AND value in adjacent columns match criteria | Excel Worksheet Functions | |||
| How do I use countif across non-adjacent cells? | Excel Worksheet Functions | |||
Threaded Mode
