| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using COUNTIF with criteria in an adjacent column?
Is this possible? I have a structure like this:
A B ------------------- 5/10 5/10 6/10 5/12 5/25 5/15 5/16 5/30 I'd like to count the number of entries in column A only if the adjacent cell in column B is blank. So, in the example above, I'd want to see a count of 2 as the answer. Can I use the COUNTIF for this, maybe with OFFSET? Or do I need to do a database function? Seems like it ought to be easy, but I'm missing something... Thanks for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Using CountIf with non-adjacent cells in same column | Excel Discussion (Misc queries) | |||
| countif = < AND value in adjacent columns match criteria | Excel Worksheet Functions | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| Sum column if multiple criteria are met in adjacent cells | Excel Worksheet Functions | |||
Threaded Mode
