Hi all,

Was wondering if anyone could help.

I have 6 worksheets each containing a table as so

A4 down has dates
B4 down has one set of data "quality"
C4 down has one set of data "score"
etc... across to G4.

I want to set up another sheet that contains the average of the
corresponding cells
ie:=SUM(Andrew!B4,Lucy!B4,Corina!B4,Owen!B4,Anthon y!B4,Bruce!B4)/6

My problem is sometimes there is do data in one of the cells :ie
Owen!B4.value = 0

I want the average of the cells excluding the cells that have a zero.

I can do this using
={AVERAGE(IF(B3:B16<0, B3:B16,""))} for data on the same sheet, but
how do I do it across sheets?

Thanks Much


--
madduck
------------------------------------------------------------------------
madduck's Profile: http://www.excelforum.com/member.php...o&userid=36313
View this thread: http://www.excelforum.com/showthread...hreadid=560951