I now have need for a formula to count occurances of Word1 in Column
B, but only if it is NOT in column A

=SUMPRODUCT((NOT($A$1:$A$100="Word1"))*($B$1:$B$10 0="Word1"))




Uzytkownik "Richard" napisal w wiadomosci
...
Hello again

You guys kindly helped me with SUMPRODUCT.
The formula you helped with with was =SUMPRODUCT((A1:A100="word1")*
(B1:B100="word2"))

I now have need for a formula to count occurances of Word1 in Column
B, but only if it is NOT in column A
And another to count occurances of Word1 in Column C, but only if it
is NOT in Column B or Column A.

Tried putting a minus in place of the * but without success.


Thanks in advance

Richard