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.

One way:

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

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

In article <jliz2803.23p56y_1140722104.1471@excelforum-nospam.com>,
jliz2803 <jliz2803.23p56y_1140722104.1471@excelforum-nospam.com>
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.