Since you mentioned using additional criteria for the string searches, you
could also reference a cell to contain that variable criteria, so that the
formula itself wouldn't have to be revised:

=SUMPRODUCT((C2:C272=F273)*(C2:C272<=F274)*(ISNUM BER(SEARCH(F275,D2:D272)))
)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"RagDyeR" wrote in message
...
Try this,
With dates in Column C and strings in Column D:

=SUMPRODUCT((C2:C272=F273)*(C2:C272<=F274)*(ISNUM BER(SEARCH("INT",D2:D272))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"colin_b" wrote in
message ...

Hi Folks,
Thanks to all of you for your assistance. I have not made my problem
clear... sorry.

I have a named area of cells (C2:C272 and D2:d272) called JOINED. This
contains two columns, one with dates (formatted to date) and one column
of strings.

I have two list boxes. Both contain the date column information.
These are located at F272 and F273.

So, when a user selects the From date (F272) and the To date (F273), I
want to return how many strings containing "INT" (or "SYS" etc) there
are in the JOINED columns between the chosen dates. I then use this
result for a graph.

I hope this is clearer.

Thanks again for you help,

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