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

Counting a text value between dates
 

Better to use SUMPRODUCT. See countless examples in the archives of this
group.
--
David Biddulph

"Lucy_C" wrote in message
...
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

Counting a text value between dates
 

=SUMPRODUCT(--(I2:I30DATE(2009,1,1)),--(I2:I30<DATE(2009,1,31)),--(B2:B30="B02"))
Adjust ranges!
If you want to refer entire columns you must use Excel2007!


Regards,
Stefi

€žLucy_C€� ezt Ã*rta:

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