Hi Bob,
Thanks for responding but this solution that you provided does not work
for me. I am counting for strings INT, e.g. SYS-INT-1496.
What I have is two columns of data, column A contains strings like the
example above, column b contains dates. The user can select 2 dates
from two list boxes at 2 cells.
I want to count the number of times the string appears between those
dates.
So my approach is:
count in the range A:B, where range is =Date1 AND <=Date2 AND contains
the string "*INT*"
Can you assist me with this?
Thanks in advance,
Colin


--
colin_b
------------------------------------------------------------------------
colin_b's Profile: http://www.excelforum.com/member.php...o&userid=36106
View this thread: http://www.excelforum.com/showthread...hreadid=558799