Sum Vs. Avg
 

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

=AVERAGE(Sheet1!A19+Sheet2!A19)

Thanks
--
NotGood@All

Sum Vs. Avg
 

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

Sum Vs. Avg
 

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.

"NotGood@All" wrote in message
...
Can someone tell me why this gives me the "Sum" and not the "Avg"

=AVERAGE(Sheet1!A19+Sheet2!A19)

Thanks
--
NotGood@All