Hello bost78, welcome to MrExcel
Which version of Excel are you using? If you have Excel 2007 or later you can use AVERAGEIFS function (with an "S" on the end), e.g.
=AVERAGEIFS(A1:A100,A1:A100,">0",B1:B100,"John")
or in earlier versions you can use this "array formula"
=AVERAGE(IF(A1:A100>0,IF(B1:B100="John",A1:A100)))
confirmed with CTRL+SHIFT+ENTER