| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if for more than one criteria
For several items listed in rows, I have one column with values "old" and
"new" . In each column in the array I have months from 01/2004 through 12/2014. I want to count values in the array that are more than 0.2 and "new" in one row and more than 0.2 and "old" in a second row. The problem is that count if only counts either more than 0.2 values or "old" or "new". Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Criteria count | Excel Discussion (Misc queries) | |||
| count using criteria | Excel Discussion (Misc queries) | |||
| How to count nos. on 3 criteria | Excel Worksheet Functions | |||
| Count If 3 Criteria Met | Excel Worksheet Functions | |||
Threaded Mode
