How to Sum with two if statements

J

jliz2803

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