Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|