Try this

=AVERAGE(Sheet1:Sheet2!A19)
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"NotGood@All" wrote:

Can someone tell me why this gives me the "Sum" and not the "Avg"

=AVERAGE(Sheet1!A19+Sheet2!A19)

Thanks
--
NotGood@All