Question about Microsoft Excel for PC
Yes, there is a function in MS Excel called "sumproduct" which multiplies the componenets in an array or arrays, then totals the result, eg :
=SUMPRODUCT(D4:D20,B4:B20) ...Job done...Enjoy !
Posted on Jan 19, 2008
Jan 19, 2016 | Business & Productivity Software
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Jan 14, 2009 | Microsoft Office Excel 2003 for PC
Dec 03, 2008 | Microsoft Office Professional 2007 Full...
Sep 20, 2008 | Microsoft Business & Productivity Software
Aug 25, 2008 | Microsoft Office Professional 2007:...
Apr 04, 2008 | Microsoft Excel for PC
Dec 19, 2007 | Microsoft Excel for PC
Sep 23, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
200 people viewed this question
Usually answered in minutes!
×