Multiple Criteria using countif
One way
=SUMPRODUCT((ISNUMBER(SEARCH("work",A1:A60)))*((D1 :D60={"m","c"})))
--
Regards,
Peo Sjoblom
"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.
|