=SUMPRODUCT((A1:A100="word1")*(B1:B100="word2"))*1 0
and see:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
for the "rest of the story"
--
Gary''s Student - gsnu2007L


"Richard" wrote:

Hi all

I need to count all instances of Word1 in column A, but only where
column 2 contains Word2. (and then multiply the result by a factor of
n - if that's possible?)

I've got as far as: =COUNTIF(A:A,"Word1")*10 - but it stops working
when I add the column 2 criteria.

Have tried using =SUMPRODUCT but think that is for numbers only?

Hope my requirements are possible.

thanks in advance

Richard