How do I make this addition formula more simple.
=SUM(C4*C$2+D4*D$2+E4*E$2+F4*F$2+G4*G$…
Also, using this formula, I have to manually enter in a new column if I add on to it. Is there a way I can use a range?
Excel Formula Help….?
By WinPie Posted in: excel
Leave a Reply
You must be logged in to post a comment.
See More Infomations
New Articles in Category6
- I Know How To Normally Print From Excel But I Have A Doc I Can’t Save (overtop Someone Else’s Doc)?
- Excel Macro Help Pleasee!!!?
- Excel – Merging Workbooks. Please Help?
- How Do You Calculate The Standard Deviation Of This?
- In Excel, How To Tally Calls Over 2 Minutes, Under 2 Minutes In A List?
- Can Asians Do Everything Perfectly Or What?
More Interesting Things
©2011 Windows Pie, All rights reserved.
yes, a range is a good idea
use the SUMPRODUCT()
=SUMPRODUCT((C$2:G$2)*(C4:G4))
since you formula gets cutoff, i only went to G, but change both those G’s to Q or whatever.
enjoy
To do a range using the Sum formula type it like this SUM(A1:A9)