count the number of cells with specific texts and also have a value greater than 0 in an adjacent cell

[jpeters7635]

I've tried a few different formulas but none seem to help when trying to only tally when specific text is found in the adjacent column. I'm trying to count the number of cells that contain a value greater than zero in each month, but have it only count when the roles in the second column are found.

For instance, "Office Manager and Office Assistant" would only count in the "Office Count" # and the "Field Supervisor and Field Tech roles" would be counted in the field count. Thansk for any help!

Name	Role	Jan	Feb	Mar
John Doe	Office Manager	1400	1450	2000
Jane Smith	Office Assistant	1200	0	1500
George Washington	Field Supervisor	1700	1900	0
Bugs Bunny	Field Tech	0	800	900
	Office Count	2	1	2
	Field Count	1	2	1

 

[jasonb75]

This should do it

Book1
	A	B	C	D	E
1	Name	Role	Jan	Feb	Mar
2	John Doe	Office Manager	1400	1450	2000
3	Jane Smith	Office Assistant	1200	0	1500
4	George Washington	Field Supervisor	1700	1900	0
5	Bugs Bunny	Field Tech	0	800	900
6
7		Office	2	1	2
8		Field	1	2	1
Sheet2

Cell Formulas
Range	Formula
C7:E8	C7	=COUNTIFS($B$2:$B$5,$B7&"*",C$2:C$5,">0")