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.