Count number of occurrences conditionally on adjacent cells

[toehrtman]

I’m trying to create a formula in Excel 2010 that will count the total number of cells with a value greater than 0 conditionally on the value of an adjacent cell. In the example below, I would want to know that John Doe has 4 accounts that submitted more than 1 item and Sally Smith has 3 accounts with more than 1 submission.

Sheet 1
Account Num Account Representative Number Submitted
1 John Doe 5
2 John Doe 0
3 John Doe 1
4 John Doe 2
5 John Doe 3
6 John Doe 0
7 Sally Smith 0
8 Sally Smith 3
9 Sally Smith 5
10 Sally Smith 0
11 Sally Smith 2

Sheet 2
Account Representative Total accounts submitting at least One Item
John Doe <Formula-?>
Sally Smith <Formula-?>

[tigeravatar]

toehrtman,

Welcome to the forum!
It sounds to me like you want the CountIfs() formula. Attached is an example workbook based on the criteria you provided. In Sheet2 cell B2 and copied down is this formula:
=COUNTIFS(Sheet1!$B$2:$B$12,A2,Sheet1!$C$2:$C$12,">0")