AVERAGE IF formula and not equal to ZERO

[Guest]

I'm looking for a formula similar to the following....but one that works.

=average(if((a1:a4="jones")+(C1:C4>"0"),c1:c4))

Column A represents the sales rep column, C represents the percentage
column. I want the average of the sales rep Jones without including those
cells in C that are blank.

I've tried control shift enter but something must be wrong with my formula
because the zeros are still included.

Thank you

 

[Don Guillett]

try this with CSE
=AVERAGE(IF((A1:A4="jones")*(C1:C4>0),C1:C4))

 

[Don Guillett]

I now see that you also got answers in .misc. PLEASE do not post in more
than ONE group.