Hi!
Make a list of sheet names:
H1 = Andrew
H2 = Lucy
H3 = Corina
etc
Array entered:
=AVERAGE(IF(N(INDIRECT("'"&H1:H6&"'!B4"))<0,N(IND IRECT("'"&H1:H6&"'!B4"))))
Biff
"madduck" wrote in
message ...
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