Multiple Criteria using countif
This was perfect, thanks for your help.
"RagDyeR" wrote:
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.
|