Excel 2010 multiply sheets

[Arlene012248]

How do you get a upside down comma? Problem use the sum and average functions, 3=d references and copy and paste capabilities of excel to total the corresponding cells on the three store sheets.
first, computer the sum in cellb5 and the compute the average in cell 5. Copy the range b4:c5to the range b5:c11. The only way that sum will work is if i am in b4 and then it is off a line. When i click =sum and try to go to the next page it will not let me enter above the formula like it is suppose to. i have another problem but I will wait until I fix this one.

 

[martindwilson]

????? would you like to start again

 

[Arlene012248]

i finally figured out how to sum several sheets, but when I use the =average the same way it does not work. I used =average(sheet2:sheet4!C5) but it gives me #div/o as a answer. The book says to use average functions, 3-D references and copy and paste capabilities of Excel to total corresponding cells on the three sheets. What am I doing wrong. The teacher sure will not help me.