I used one of T. Valko's solutions. I wasn't trying to count occurrences. I
was trying to set the value of a cell based on the occurrence of a text
string appearing in any one of the cells of the array. It could be done in
two steps using the COUNTIF in the first step but I simply had to add the AND
operator ans some parentheses to make my formula work. Thanks for responding.
--
- Andrew L


"Jarek Kujawa" wrote:

hope I follow you

to count the number of occurrences of "MAPPED TO:" in G6:G15 array
use:

=SUM(IF(G6:G15="MAPPED TO:",1,))
(array-enter it = CTRL+SHIFT+ENTER, instead of using ENTER only)