Hey im doing excel at school and have used this equation:

=((A1+B1+C1+D1+E1+F1+G1+H1)*$M$2)

I tried replacing the long chain on plus with A1:H1 but it seemed to fail.

Quick solution please?