Multiple Criteria using countif
=SUMPRODUCT(--(ISNUMBER(FIND("Work",A1:A60))),--(ISNUMBER(MATCH(D1:D60,{"c",
"m"},0))))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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.
|