close
Say the data is in A1:B6
=SUMPRODUCT(--(A1:A6=quot;Aquot;),--(B1:B6=quot;Aquot;))quot;ScottyCquot; wrote:
gt; Hi
gt;
gt; i am trying to get Excel to tell me the number of times a value appears in
gt; both column a and columb b. for example:
gt;
gt; a a
gt; a n
gt; a a
gt; m a
gt; a a
gt; m d
gt;
gt; the result i am looking for excel to come up with is 3.
gt;
gt; i have been trying for about 3 days now with no luck
gt;
gt; does anyone have suggestions?
gt;
gt; Thanks
全站熱搜
留言列表
