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?
try this out
=sum(A1:h1)*$M$2
Shijesh Kumar
http://shijesh.wordpress.com/
Read the Forum Rules & use appropriate titles for your threads. Also post in the correct sub-forum.Originally Posted by Craiig
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks