View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lucy_C Lucy_C is offline
external usenet poster
 
Posts: 1
Default 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