Counting a text value between dates

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
 
D

David Biddulph

Better to use SUMPRODUCT. See countless examples in the archives of this
group.
 
S

Stefi

=SUMPRODUCT(--(I2:I30>DATE(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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Dates between Dates exclude Text 3
counting based on two dates 2
Counting Cells with Multiple Range Criteria (Excel 2003) 7
Count specific days in between dates 2
LOOKUP function between two dates in Excel 2007 6
Check if a date comes before/after a range of dates 0
dates inbetween 3
Distributing cell value (not text-to-columns) 7

Top