Add another if statement right before you do the average:
=AVERAGE(IF(Prov!$A$2:$A$2978=$A2,IF(Prov!$R$2:$R$ 2978=0,"",Prov!$R$2:$R$2978),""))
--
Regards,
Dave
"Tom" wrote:
{=AVERAGE(IF(Prov!$A$2:$A$2978=$A2,Prov!$R$2:$R$29 78))}
Above is a formula that succesfully averages what I want. However
sometime the Prov!range r2:R2978 contains zeros.
How can I eliminate those zeros from the average?
The first part of the formula with the cell reference is looking up and
match a name before performin the average..
TIA
Tom
|