Sum Vs. Avg

[NotGood@All]

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

=AVERAGE(Sheet1!A19+Sheet2!A19)

Thanks

 

[Barb Reinhardt]

Try this

=AVERAGE(Sheet1:Sheet2!A19)

 

[Fred Smith]

Yes. You told Excel to sum the two numbers (that's what the + sign does),
then take the average of that sum.

You probably want:
=AVERAGE(Sheet1!A19,Sheet2!A19)

Regards,
Fred.