L
Lucy_C
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
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