#Value! is common because of using NA instead of a time.

AVERAGE ignores text entries when they are part of a referenced array.

Also there will be some non value numbers

What are non value numbers?

Did you try something like this:

=AVERAGE(Sheet1:Sheet4!J2:J46)

Or, if the sheets are random:

=AVERAGE(Sheet1!J2:J46,Sheet5!J2:J46,Sheet7!J2:J46 ,Sheet10!J2:J46)

--
Biff
Microsoft Excel MVP


"ericaamousseau" wrote in message
...
I can not figure this out! I need to average multiple rows of data in 4
different worksheets. The biggest problem is that the data is calculated
from time differences, so #Value! is common because of using NA instead of
a
time. So say I need J2:J46 in worksheet one J2:J46 in worksheet 2 J2:J46
in
worksheet 3 and J2:J46 in worksheet 4 all averaged together. Also there
will
be some non value numbers. Help!