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...??
- Sep 29 Fri 2006 20:09
How can I sum certain entries in a column by reference letters
close
全站熱搜
留言列表
發表留言