software

I have one column that has DSM or eBiz, and another column has a 1 or a
0. I need a total for DSM which increments by 1 with rows that include
DSM in column A and 1 in column G, as well as a total for eBiz which
increments by 1 with rows that include eBiz in column A and 1 in column
B.--
jliz2803
------------------------------------------------------------------------
jliz2803's Profile: www.excelforum.com/member.php...oamp;userid=31498
View this thread: www.excelforum.com/showthread...hreadid=515925One way:

=SUMIF(A:A, quot;DSMquot;, G:G)

=SUMIF(A:A, quot;eBizquot;, B:B)

In article gt;,
jliz2803 gt;
wrote:

gt; I have one column that has DSM or eBiz, and another column has a 1 or a
gt; 0. I need a total for DSM which increments by 1 with rows that include
gt; DSM in column A and 1 in column G, as well as a total for eBiz which
gt; increments by 1 with rows that include eBiz in column A and 1 in column
gt; B.