I'm assuming that the asterisks around "*Work*" indicate that there may be
characters before and/or after the string in the cell.

Start by entering this in the sheet containing the data:

=SUMPRODUCT((ISNUMBER(SEARCH("work",A1:A60)))*(D1: D60={"m","c"}))

Now, open the *other* WB, and copy this formula to it, which will allow XL
to create the proper path for you.

--

HTH,

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

"calmo" wrote in message
...
I'm trying to count the number of records in one worksheet and return the
results in a different workbook. The data is held in two different columns.
I nned to search for all cells where the value is "m" or "c" in D1:D60,
whilst column A1:A60 should contain "*Work*".
Sorry if I'm not explaining myself properly, I'm new to this! Any help
greatly appreciated.