Quicker way?

try this out


=sum(A1:h1)*$M$2

Originally Posted by Craiig

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?

Read the Forum Rules & use appropriate titles for your threads. Also post in the correct sub-forum.