Got a sheet with formula
=SUMPRODUCT(--(ISNUMBER(SEARCH("yes",raw_data!$D$2:$D$8002))*(--(ISNUMBER(SEARCH(D2,raw_data!$U$2:$U$8002))))))
- basically it is searching another sheet for number of 'yes' responses from
group of people in D2 (i.e. sales).

Works fine but is counting "sales & marketing", "web sales" etc - I only
want it to count lines that have a "yes" and "sales" only - hope that makes
sense.

Any help gratefully rec'd.

--
DJ