close
Hi, trying to find way to count occurances of text in a column, thanks.
=COUNT(LEFT(R100:R3000,1)=quot;xquot;)
=SUMPRODUCT(--(LEFT(R100:R3000,1)=quot;xquot;))
Regards,
Stefi
?astech??ezt ?rta:
gt; Hi, trying to find way to count occurances of text in a column, thanks.
gt;
gt; =COUNT(LEFT(R100:R3000,1)=quot;xquot;)
Another way:
=COUNTIF(R100:R3000,quot;x*quot;)
nastech wrote:
gt;
gt; Hi, trying to find way to count occurances of text in a column, thanks.
gt;
gt; =COUNT(LEFT(R100:R3000,1)=quot;xquot;)
--
Dave Peterson
全站熱搜
留言列表
