How to Sum with two if statements
 

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: http://www.excelforum.com/member.php...o&userid=31498
View this thread: http://www.excelforum.com/showthread...hreadid=515925

How to Sum with two if statements
 

One way:

=SUMIF(A:A, "DSM", G:G)

=SUMIF(A:A, "eBiz", B:B)

In article ,
jliz2803
wrote:

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.