close

I am trying count count the number of occurances of a value = or gt; than
(E7 2) but cannot workout the syntax. Can anybody kindly point me in the
right direction?

=COUNTIF(E13:E15,(E7 2))

Mark
Hi

=COUNTIF(E13:E15,quot;gt;=quot; amp; (E7 2))

Arvi Laanemetsquot;Mark Wquot; gt; wrote in message
...
gt; I am trying count count the number of occurances of a value = or gt; than
gt; (E7 2) but cannot workout the syntax. Can anybody kindly point me in the
gt; right direction?
gt;
gt; =COUNTIF(E13:E15,(E7 2))
gt;
gt; Mark
gt;
gt;
Great stuff thanks Arvi

Markquot;Arvi Laanemetsquot; gt; wrote in message
...
gt; Hi
gt;
gt; =COUNTIF(E13:E15,quot;gt;=quot; amp; (E7 2))
gt;
gt; Arvi Laanemets
gt;
gt;
gt; quot;Mark Wquot; gt; wrote in message
gt; ...
gt; gt; I am trying count count the number of occurances of a value = or gt; than
gt; gt; (E7 2) but cannot workout the syntax. Can anybody kindly point me in the
gt; gt; right direction?
gt; gt;
gt; gt; =COUNTIF(E13:E15,(E7 2))
gt; gt;
gt; gt; Mark
gt; gt;
gt; gt;
gt;
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()