Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting a text value between dates
I am trying to count the number of times a particular phrase occurs in a
column using a combilation of 'if' and 'countif' my knowlegde of basic dates back to the time when every line started with a number! but I am trying to do something along the lines of IF !$I:$I 01/01/09 or !$I:$I <31/01/09 then CountIf !$B:$B = "B02 But nothing I seem to do brings up the correct result, any help gratefully received. Lucy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Dates - Not Text | Excel Worksheet Functions | |||
Counting Dates - Not Text | Excel Worksheet Functions | |||
Counting Dates - Not Text | Excel Worksheet Functions | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting dates, within a list of dates | Excel Worksheet Functions |