close

I'm trying to sum certain entries in a column by a reference letter in
another column. For instance trying to get a total of all the quot;Aquot; entries all
the quot;Bquot; entries, and so on, in a single cell?? Please Help...??

Hi

Have a look at SUMIF(). There are other alternatives but that is the
simplest - if it does what you want.

Andy.

quot;Philquot; gt; wrote in message
news
gt; I'm trying to sum certain entries in a column by a reference letter in
gt; another column. For instance trying to get a total of all the quot;Aquot; entries
gt; all
gt; the quot;Bquot; entries, and so on, in a single cell?? Please Help...??
If you have lots of different quot;entriesquot;, then you might want to consider the
Data gt; SubTotals feature..........

Vaya con Dios,
Chuck, CABGx3
quot;Philquot; wrote:

gt; I'm trying to sum certain entries in a column by a reference letter in
gt; another column. For instance trying to get a total of all the quot;Aquot; entries all
gt; the quot;Bquot; entries, and so on, in a single cell?? Please Help...??

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

    software

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