close
If you only need the total (and not a list of every matching entry), you can
use sumif: =sumif(c:c,quot;Walmartquot;,d:d)
quot;Susanquot; wrote:
gt; I am trying to get data that is listed in two seperate columns. For instance:
gt; Column C has text fields and I know how to use the countif function to
gt; locate it- however I also need the number value in column D that corresponds
gt; to the text record in column c
gt;
gt; column c column d
gt; walmart $50.00
gt; aol $25.00
gt; I want to be able to pull all the walmart entries with the corresponding
gt; money value in order to total up the amounts.
全站熱搜
留言列表
