AVERAGE IF formula and not equal to ZERO
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
--
Lori
|