R
Richard
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
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