=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(INDIRECT("1 :3"))&"!A1:A52"),"0"))/
SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&ROW(INDIRECT(" 1:3"))&"!A1:A52"),"0"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Willabo" wrote in message
...
I've got a sheet consolidating the data from various detail sheets... I
need
to create a formula for the average percentage excluding zero values...
i've
got the following formula =AVERAGE(IF(A1:A520,A1:A52)) but that doesn't
give
the option of using information from different tabs (the data is in the
same
cell in each tab)... any ideas?!

Cheers