Try this
=average($A$5:$P$5)

"Linda" wrote:

I need to do exact formula copying in my spread sheet. I need to copy this
formula: =average(A5:P5). When I tried to copy the formula to the next cell,
it changed to =average(B5:Q5). I need the formula to stay as =average(A5:P5).

Can somebody show me how to do that?

Thank you,
Linda