| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif with two criteria one a column of dates?
I have two columns and am entering the following formula
=COUNTIF($B$2:$B$436,"**-AU-****")+COUNTIF($A$2:$A$436,"**/**/2005") The wildcards in the B column are used to show that I only want to count the cells in that column that have AU in the middle. I then want to break it down futher by counting how many times 2005 appears in the corresponding cell of column A This is not working - where am I going wrong please? -- Thanks as always Lise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Countif with multiple criteria in the same column. | Excel Discussion (Misc queries) | |||
| Use multiple criteria with COUNTIF: between dates and not blank | Excel Worksheet Functions | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| COUNTIF, dates and blank cell criteria | Excel Discussion (Misc queries) | |||
| How do you use countif for several column criteria? | Excel Worksheet Functions | |||
Threaded Mode
