document.write('<div class="feedburnerFeedBlock" id="microsoft/pTwWdc9rcmcuvboiv0d6399ld2hlf0">');
document.write('<p class="feedTitle">Sumproduct Function</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb239778.aspx" target="_blank" >SumProduct Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Multiplies corresponding components in the given arrays, and returns the sum of those products.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/aSfz4GmPgNXqRqdzQP5FCRO6kNM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/aSfz4GmPgNXqRqdzQP5FCRO6kNM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/aSfz4GmPgNXqRqdzQP5FCRO6kNM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/aSfz4GmPgNXqRqdzQP5FCRO6kNM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa730921.aspx" target="_blank" >Improving Performance in Excel 2007</a></span>');
document.write('<div>SUMPRODUCT does not have to be array-entered by using CTRL+SHIFT+ENTER. SUMPRODUCT is usually slightly faster (5 to 10 percent). You can use SUMPRODUCT for multiple-condition array ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/kKPqkw3PYeZDg6xMw2PI2KnIWd8\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/kKPqkw3PYeZDg6xMw2PI2KnIWd8\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/kKPqkw3PYeZDg6xMw2PI2KnIWd8\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/kKPqkw3PYeZDg6xMw2PI2KnIWd8\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/b0314e6f-408f-4bca-bde8-819d9e826c86/" target="_blank" >sumproduct with SQL</a></span>');
document.write('<div>I would like to calculate a sumproduct, but on the values where i have records -1, I would like a result \"cero\" for example pit bench ton tcu ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ph_FErDGIO1zjRfaY22Xz7Suog0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ph_FErDGIO1zjRfaY22Xz7Suog0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ph_FErDGIO1zjRfaY22Xz7Suog0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ph_FErDGIO1zjRfaY22Xz7Suog0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/09/24/adding-every-other-cell-in-a-column.aspx" target="_blank" >Microsoft Excel : Adding Every Other Cell in a Column</a></span>');
document.write('<div>=sumproduct(--(iseven(row(a1:a5))),a1:a5) but these don\'t work: =sumproduct(--(iseven(a1:a5)),a1:a5) = #value! =sumproduct((iseven(a1:a5))*a1:a5) = #value!\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/V7F79q35rjZRW3CGbpJeIVwo_Js\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/V7F79q35rjZRW3CGbpJeIVwo_Js\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/V7F79q35rjZRW3CGbpJeIVwo_Js\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/V7F79q35rjZRW3CGbpJeIVwo_Js\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/dd789430.aspx" target="_blank" >Using Excel 2007 Functions in Access 2007</a></span>');
document.write('<div>AddLine \"SumX2PY2:\", obj.SumX2PY2(varCol1, varCol2) AddLine \"SumSQ:\", obj.SumSQ(varCol1) AddLine \"SumProduct:\", obj.SumProduct(varCol1, varCol2) AddLine \"StDev ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GtwpAjvvUtuxkBSs2qVC_AlIj84\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GtwpAjvvUtuxkBSs2qVC_AlIj84\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GtwpAjvvUtuxkBSs2qVC_AlIj84\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GtwpAjvvUtuxkBSs2qVC_AlIj84\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheetfunction.sumproduct(office.11).aspx" target="_blank" >WorksheetFunction.SumProduct Method (Microsoft.Office.Interop.Excel)</a></span>');
document.write('<div>For information about this worksheet function, see the Help for worksheet functions on Office Online.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/rVP1aayCLsHLd5640jrdSQWFOfI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/rVP1aayCLsHLd5640jrdSQWFOfI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/rVP1aayCLsHLd5640jrdSQWFOfI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/rVP1aayCLsHLd5640jrdSQWFOfI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.iworksheetfunction.sumproduct(office.11).aspx" target="_blank" >IWorksheetFunction.SumProduct Method (Microsoft.Office.Interop.Excel ...</a></span>');
document.write('<div>This method supports the .NET Framework infrastructure and is not intended to be used directly from your code.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/H3ejwR_0Jx5FuNAFwXun2nYpN0Y\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/H3ejwR_0Jx5FuNAFwXun2nYpN0Y\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/H3ejwR_0Jx5FuNAFwXun2nYpN0Y\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/H3ejwR_0Jx5FuNAFwXun2nYpN0Y\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/109211" target="_blank" >Calculating Weighted Averages</a></span>');
document.write('<div>A weighted average differs from an average in that a weighted average returns a ... =SUMPRODUCT(A2:A3,B2:B3)\/SUM(B2:B3)\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/g5wNTgBWhrClAWV_tXjlxZeoFVY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/g5wNTgBWhrClAWV_tXjlxZeoFVY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/g5wNTgBWhrClAWV_tXjlxZeoFVY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/g5wNTgBWhrClAWV_tXjlxZeoFVY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214049" target="_blank" >How to calculate weighted averages in Excel 2000</a></span>');
document.write('<div>A weighted average differs from an average in that a weighted average returns a number ... =SUMPRODUCT(A2:A3,B2:B3)\/SUM(B2:B3)\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/QlBQA-l77QHlz3ITZ7ZkBVPEou4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/QlBQA-l77QHlz3ITZ7ZkBVPEou4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/QlBQA-l77QHlz3ITZ7ZkBVPEou4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/QlBQA-l77QHlz3ITZ7ZkBVPEou4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/132221" target="_blank" >XL7: Array Formulas Return #NUM! Error Value</a></span>');
document.write('<div>A1: =SUMPRODUCT(A2:BT77) ... This behavior occurs because in Microsoft Excel, the maximum array size is 5458 ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/FdZim8sqzLrb9x0ewZQ2kKN6Ucw\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/FdZim8sqzLrb9x0ewZQ2kKN6Ucw\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/FdZim8sqzLrb9x0ewZQ2kKN6Ucw\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/FdZim8sqzLrb9x0ewZQ2kKN6Ucw\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2008/12/03/using-excel-to-optimize-a-network-problem.aspx" target="_blank" >Microsoft Excel : Using Excel to Optimize a Network Problem</a></span>');
document.write('<div>SUMPRODUCT will return the sum of the products of the two ranges I give it in this case (Route Select x Number of Hikes). So let\'s label C17 as \"Number of Hikes\" and insert the ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yQt624JSuNw2PGEm3ZBWe-aRKBU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yQt624JSuNw2PGEm3ZBWe-aRKBU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yQt624JSuNw2PGEm3ZBWe-aRKBU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yQt624JSuNw2PGEm3ZBWe-aRKBU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/166342" target="_blank" >Description of the limitations for working with arrays in Excel</a></span>');
document.write('<div>SUMPRODUCT() TRANSPOSE() TREND() Note The following facts about the functions are helpful to remember. If any cells in an array are empty or contain text, MINVERSE returns the ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/woJ-pJZjucNY_xFL6dxpnUBoBHs\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/woJ-pJZjucNY_xFL6dxpnUBoBHs\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/woJ-pJZjucNY_xFL6dxpnUBoBHs\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/woJ-pJZjucNY_xFL6dxpnUBoBHs\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers.aspx" target="_blank" >Microsoft Excel : Understanding Floating Point Precision, aka \u201CWhy ...</a></span>');
document.write('<div>=SUMPRODUCT(Sales[Quantity],Sales[Jan]) If I copy that across I get: =SUMPRODUCT(Sales[Quantity],Sales[Jan]) =SUMPRODUCT(Sales[Jan],Sales[Feb]) =SUMPRODUCT(Sales[Feb],Sales[Mar])\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/jhSPLZbAM1TGNoBheXZknWl5XSE\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/jhSPLZbAM1TGNoBheXZknWl5XSE\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/jhSPLZbAM1TGNoBheXZknWl5XSE\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/jhSPLZbAM1TGNoBheXZknWl5XSE\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/192377" target="_blank" >XL98: Calculating Weighted Averages</a></span>');
document.write('<div>A weighted average differs from an average in that a weighted average returns a ... =SUMPRODUCT(A2:A3,B2:B3)\/SUM(B2:B3)\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/v7x_bQVZBki620m8OXXafX0-6cQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/v7x_bQVZBki620m8OXXafX0-6cQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/v7x_bQVZBki620m8OXXafX0-6cQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/v7x_bQVZBki620m8OXXafX0-6cQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/02/24/538875.aspx" target="_blank" >Microsoft Excel : Conditional Formatting Trick 1 \u2013 Multi-Coloured ...</a></span>');
document.write('<div>Kanwal - You can use a normally entered Sumproduct formula which will evaluate just fine: =SUMPRODUCT(--($H$4:H715>=$AG$1),--($I$4:I715<>\"Swi\"))\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/70g4I_FfdVrNXM3na_AqZv5vRGY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/70g4I_FfdVrNXM3na_AqZv5vRGY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/70g4I_FfdVrNXM3na_AqZv5vRGY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/70g4I_FfdVrNXM3na_AqZv5vRGY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=74069&ANCHOR" target="_blank" >PHPExcel - Discussions - Different results with Excel5\/Excel2007 using ...</a></span>');
document.write('<div>Secondly, SUMPRODUCT() isn\'t yet implemented in the calculation engine, so the result of this formula cannot be calculated internally by PHPExcel.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/mYn5exv9jT3XqNaGGvDPC4InYzo\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/mYn5exv9jT3XqNaGGvDPC4InYzo\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/mYn5exv9jT3XqNaGGvDPC4InYzo\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/mYn5exv9jT3XqNaGGvDPC4InYzo\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/08/13/the-dislpayformat-om.aspx" target="_blank" >Microsoft Excel : The DisplayFormat OM</a></span>');
document.write('<div>or its equivalent SUMPRODUCT. Or with a little lookup table =LOOKUP(SUMPRODUCT(--(B12:E12>=B2:E2)),J$1:K$3) or the array equivalent =LOOKUP(SUM(--(B12:E12>=B2:E2)),B$19:C$21)\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/kUYVICxWwEO4QpTGuIv8irSoo7k\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/kUYVICxWwEO4QpTGuIv8irSoo7k\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/kUYVICxWwEO4QpTGuIv8irSoo7k\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/kUYVICxWwEO4QpTGuIv8irSoo7k\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://beta.blogs.msdn.com/excel/archive/2009/09/24/adding-every-other-cell-in-a-column.aspx" target="_blank" >Microsoft Excel : Adding Every Other Cell in a Column</a></span>');
document.write('<div>=sumproduct(--(iseven(row(a1:a5))),a1:a5) but these don\'t work: =sumproduct(--(iseven(a1:a5)),a1:a5) = #value! =sumproduct((iseven(a1:a5))*a1:a5) = #value!\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/aUvWL8oxoUsB1i5bIpip7AbbSZ0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/aUvWL8oxoUsB1i5bIpip7AbbSZ0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/aUvWL8oxoUsB1i5bIpip7AbbSZ0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/aUvWL8oxoUsB1i5bIpip7AbbSZ0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/08/15/701779.aspx" target="_blank" >Microsoft Excel : Developer Tab</a></span>');
document.write('<div>=SUMPRODUCT((A1:A10<>\"\")\/COUNTIF(A1:A10,A1:A10&\"\")) Try this in a *new* wb: Do not enter any data in A1:A10 yet. Enter the above formula in D1.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/YQ0swSgpIvrNOl7pI5Fd9kwXdLg\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/YQ0swSgpIvrNOl7pI5Fd9kwXdLg\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/YQ0swSgpIvrNOl7pI5Fd9kwXdLg\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/YQ0swSgpIvrNOl7pI5Fd9kwXdLg\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2005/10/21/483661.aspx" target="_blank" >Microsoft Excel : Formula building improvements Part 4: Defined Names</a></span>');
document.write('<div>3D ranges for SUMPRODUCT has not changed from Excel 2003. Jean, Gary, Tianwei \u2013 what is the scenario you have in mind when you say \u201Cdynamic ranges\u201D?\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UTDAoKAFXvcL2qWvijAnEP1TE7U\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UTDAoKAFXvcL2qWvijAnEP1TE7U\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UTDAoKAFXvcL2qWvijAnEP1TE7U\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UTDAoKAFXvcL2qWvijAnEP1TE7U\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/841341/en-gb" target="_blank" >The secrets of Excel: formulas and functions</a></span>');
document.write('<div>SUMPRODUCT is a quick way of multiplying all the numbers in one column by the corresponding number in another column and totalling the results.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2370wKbkpMoqTAVzPUU56pCL3d0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2370wKbkpMoqTAVzPUU56pCL3d0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2370wKbkpMoqTAVzPUU56pCL3d0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2370wKbkpMoqTAVzPUU56pCL3d0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa178231(SQL.80).aspx" target="_blank" >Excel Functions</a></span>');
document.write('<div>SumProduct: SumSq: SumX2MY2: SumX2PY2: SumXMY2: Syd: Tanh: TDist: Text: TInv: Transpose *Trend: Trim: TrimMean: TTest: USDollar: Var: VarP: Vdb *VLookup: Weekday: Weibull: ZTest\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/n59wM_lvY62YOSiR1IvG5ajC9ZA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/n59wM_lvY62YOSiR1IvG5ajC9ZA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/n59wM_lvY62YOSiR1IvG5ajC9ZA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/n59wM_lvY62YOSiR1IvG5ajC9ZA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa221655(office.11).aspx" target="_blank" >List of Worksheet Functions Available to Visual Basic [Excel 2003 VBA ...</a></span>');
document.write('<div>SumProduct. SumSq. SumX2MY2. SumX2PY2. SumXMY2. Syd. Tanh. TDist. Text. TInv. Transpose. Trend. Trim. TrimMean. TTest. USDollar. Var. VarP. Vdb. VLookup. Weekday. Weibull. ZTest\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/LXTyyscR9t2uxWDBYUxg_FUXU5I\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/LXTyyscR9t2uxWDBYUxg_FUXU5I\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/LXTyyscR9t2uxWDBYUxg_FUXU5I\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/LXTyyscR9t2uxWDBYUxg_FUXU5I\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa272490(office.10).aspx" target="_blank" >List of Worksheet Functions Available to Visual Basic</a></span>');
document.write('<div>SumProduct. SumSq. SumX2MY2. SumX2PY2. SumXMY2. Syd. T. Tanh. TDist. Text. TInv. Transpose. Trend. Trim. TrimMean. TTest. U. USDollar. V. Var. VarP. Vdb. VLookup. W. Weekday. Weibull. X. Y. Z. ZTest\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/OpwT8JKwgtZe8wLNDUe48Dc3aJE\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/OpwT8JKwgtZe8wLNDUe48Dc3aJE\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/OpwT8JKwgtZe8wLNDUe48Dc3aJE\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/OpwT8JKwgtZe8wLNDUe48Dc3aJE\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb211378.aspx" target="_blank" >List of Worksheet Functions Available to Visual Basic\u00A0[Excel 2007 ...</a></span>');
document.write('<div>SumProduct. SumSq. SumX2MY2. SumX2PY2. SumXMY2. Syd. Tanh. TBillEq. TBillPrice. TBillYield. TDist. Text. TInv. Transpose. Trend. Trim. TrimMean. TTest. USDollar. Var. VarP. Vdb. VLookup\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/W_Fjv9ADCC7lxSK0Ajgwfsn3cUU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/W_Fjv9ADCC7lxSK0Ajgwfsn3cUU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/W_Fjv9ADCC7lxSK0Ajgwfsn3cUU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/W_Fjv9ADCC7lxSK0Ajgwfsn3cUU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/01/19/when-a-number-is-not-a-number.aspx" target="_blank" >Microsoft Excel : When a Number is Not a Number</a></span>');
document.write('<div>=sumproduct(--(Rang of cells = Number)) You would have expected MS to fix this bug\/feature in Countifs and sumifs in 2007... instead they just carried it forward from Sumif\/Countif ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Qr9ChL7_mzyNz-s-jcfeM-d5v5c\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Qr9ChL7_mzyNz-s-jcfeM-d5v5c\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Qr9ChL7_mzyNz-s-jcfeM-d5v5c\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Qr9ChL7_mzyNz-s-jcfeM-d5v5c\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.iworksheetfunction_methods(office.11).aspx" target="_blank" >IWorksheetFunction Methods (Microsoft.Office.Interop.Excel)</a></span>');
document.write('<div>SumProduct Method SumSq Method SumX2MY2 Method SumX2PY2 Method SumXMY2 Method Syd Method Tanh Method TDist Method Text Method ThaiDayOfWeek Method ThaiDigit Method\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/wOHg6kfkciOTK4rDXmN3gaOswdk\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/wOHg6kfkciOTK4rDXmN3gaOswdk\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/wOHg6kfkciOTK4rDXmN3gaOswdk\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/wOHg6kfkciOTK4rDXmN3gaOswdk\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/03/23/analyzing-data-functions-of-pivottables.aspx" target="_blank" >Microsoft Excel : Analyzing Data: Functions or PivotTables</a></span>');
document.write('<div>Both SUMIFS\/COUNTIFS and Pivot tables are very efficient compared to SUMPRODUCT\/array formulae. For large datasets one major factor in the choice is the useage scenario:\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4d7CzOiLg-nauHDtUg_vKMAB0Lo\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4d7CzOiLg-nauHDtUg_vKMAB0Lo\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4d7CzOiLg-nauHDtUg_vKMAB0Lo\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4d7CzOiLg-nauHDtUg_vKMAB0Lo\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/gabhan_berry/archive/2008/04/07/writing-custom-excel-worksheet-functions-in-c_2D00_sharp.aspx" target="_blank" >Excel Programming : Writing Custom Excel Worksheet Functions in C#</a></span>');
document.write('<div>=sumproduct((1\/countif(d3:d9,d3:d9)) to get a count of unique values.... or IF(1\/countif(d3:d9,d3:d9))<1,\"\",d3:d9) - array entered to get a list of unique values.....\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tSDporpWoHhk6p5HYxD8vj-nQ_k\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tSDporpWoHhk6p5HYxD8vj-nQ_k\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tSDporpWoHhk6p5HYxD8vj-nQ_k\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tSDporpWoHhk6p5HYxD8vj-nQ_k\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/69204" target="_blank" >Works: Converting from Lotus 1-2-3 Release 3 to Works</a></span>');
document.write('<div>... Statistic Financial Mathematical ----- @DGET @D360 @ISRANGE @COORD @STDS @VDB @SUMPRODUCT ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2TqOU5xyZGz0FCEAeOQye-pBMQE\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2TqOU5xyZGz0FCEAeOQye-pBMQE\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2TqOU5xyZGz0FCEAeOQye-pBMQE\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2TqOU5xyZGz0FCEAeOQye-pBMQE\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/dd906358.aspx" target="_blank" >[MS-XLSX]: Formulas</a></span>');
document.write('<div>sumproduct-params = \"(\" (expression \/ (argument 1*254(\",\" argument))) \")\" sumsq-params = \"(\" (expression \/ (argument 1*254(\",\" argument))) \")\" sumx2my2-params = \"(\" argument ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4y-OgtfbGkbDE29blQ3ie0GIey4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4y-OgtfbGkbDE29blQ3ie0GIey4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4y-OgtfbGkbDE29blQ3ie0GIey4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4y-OgtfbGkbDE29blQ3ie0GIey4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2005/10/11/479713.aspx" target="_blank" >Microsoft Excel : New conditional formatting \"rules\" ...</a></span>');
document.write('<div>I\'d hope the latter were no less efficient than current Excel [with XL12 being able to dereference *entire* worksheets, e.g., =SUMPRODUCT(--(X!1:1048576=\"foo\"))].\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yBxALjWjjr3yzn5uq6oEt2kSHhw\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yBxALjWjjr3yzn5uq6oEt2kSHhw\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/yBxALjWjjr3yzn5uq6oEt2kSHhw\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/yBxALjWjjr3yzn5uq6oEt2kSHhw\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2005/10/28/486604.aspx" target="_blank" >Microsoft Excel : Tables Part 3: Using Formulas with Tables</a></span>');
document.write('<div>=SUMPRODUCT(SUMIFS(INDIRECT(\"Sales[\"&{2001,2002,2003,2004,2005}&\"]\"),Sales[Product],Prod,Sales[Region],Reg)) but it\'d be very nice indeed if there were new useful new syntax like\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4G2G4wlPB7paplaPE0n5XWNyEk\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4G2G4wlPB7paplaPE0n5XWNyEk\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4G2G4wlPB7paplaPE0n5XWNyEk\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/e4G2G4wlPB7paplaPE0n5XWNyEk\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/dd948579.aspx" target="_blank" >[MS-XLSB]: Ftab</a></span>');
document.write('<div>SUMPRODUCT. sumproduct-params = val *254(val) 0x00E5 . SINH. sinh-params = val. 0x00E6 . COSH. cosh-params = val. 0x00E7 . TANH. tanh-params = val\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/H8qFCb57v8ShHdI0BFykFfOqSxM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/H8qFCb57v8ShHdI0BFykFfOqSxM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/H8qFCb57v8ShHdI0BFykFfOqSxM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/H8qFCb57v8ShHdI0BFykFfOqSxM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa168292(office.11).aspx" target="_blank" >Understanding the Excel Object Model from a .NET Developer\u2019s ...</a></span>');
document.write('<div>Statistical functions such as BetaDist, BinomDist, ChiTest, ChiInv, LogNormDist, NegBinomDist, Pearson, SumProduct, SumSq, TDist, TTest, Var, VarP, and more.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/r3Q6qbuQU9mFnP7ff3zgoGCTJsA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/r3Q6qbuQU9mFnP7ff3zgoGCTJsA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/r3Q6qbuQU9mFnP7ff3zgoGCTJsA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/r3Q6qbuQU9mFnP7ff3zgoGCTJsA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/dd904817.aspx" target="_blank" >[MS-XLS]: Ftab</a></span>');
document.write('<div>SUMPRODUCT. sumproduct-params = val, *29(val) 0x00E5 . SINH. sinh-params = val. 0x00E6 . COSH. cosh-params = val. 0x00E7 . TANH. tanh-params = val\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/nSPdmMwPRtiR7xu-0U6yYVDmmTo\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/nSPdmMwPRtiR7xu-0U6yYVDmmTo\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/nSPdmMwPRtiR7xu-0U6yYVDmmTo\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/nSPdmMwPRtiR7xu-0U6yYVDmmTo\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2009/09/14/function-consistency-improvements-in-excel-2010.aspx" target="_blank" >Microsoft Excel : Function Consistency Improvements in Excel 2010</a></span>');
document.write('<div>f) Please extended 3D functionailty to all Aggregate Functions - Sumproduct+SumIF\/S+CoutIF\/S and Search and Pick functions - INDEX\/MATCH, Find, Search etc\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Rj8QPvjdxwd6CAMXMArQ-fUQEN0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Rj8QPvjdxwd6CAMXMArQ-fUQEN0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Rj8QPvjdxwd6CAMXMArQ-fUQEN0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Rj8QPvjdxwd6CAMXMArQ-fUQEN0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa537184(office.11).aspx" target="_blank" >Understanding the Excel Object Model from a Visual Studio 2005 ...</a></span>');
document.write('<div>Statistical functions such as BetaDist, BinomDist, ChiTest, ChiInv, LogNormDist, NegBinomDist, Pearson, SumProduct, SumSq, TDist, TTest, Var, VarP, and more.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/y3oIXhTy3JpBZJDPrxSMlPfWPDA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/y3oIXhTy3JpBZJDPrxSMlPfWPDA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/y3oIXhTy3JpBZJDPrxSMlPfWPDA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/y3oIXhTy3JpBZJDPrxSMlPfWPDA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/06/22/642446.aspx" target="_blank" >Microsoft Excel : Calling all PivotTable users: Let us know how you ...</a></span>');
document.write('<div>-Ability perform *accurate* weighted averages (aka SumProduct) within the GrandTotal and Subtotals. -The ability to group items without having to include them in the pivot table ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/0za1MN98FpjeRNQPx91SnES_CnU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/0za1MN98FpjeRNQPx91SnES_CnU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/0za1MN98FpjeRNQPx91SnES_CnU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/0za1MN98FpjeRNQPx91SnES_CnU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.iworksheetfunction_members(office.11).aspx" target="_blank" >IWorksheetFunction Members (Microsoft.Office.Interop.Excel)</a></span>');
document.write('<div>SumProduct SumSq SumX2MY2 SumX2PY2 SumXMY2 Syd Tanh TDist Text ThaiDayOfWeek ThaiDigit ThaiMonthOfYear ThaiNumSound ThaiNumString\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/QkrojrM6nF_t7Xsl7EK_5b0AEPs\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/QkrojrM6nF_t7Xsl7EK_5b0AEPs\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/QkrojrM6nF_t7Xsl7EK_5b0AEPs\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/QkrojrM6nF_t7Xsl7EK_5b0AEPs\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.msdn.com/excel/archive/2006/05/12/596605.aspx" target="_blank" >Microsoft Excel : And now for something completely different ...</a></span>');
document.write('<div>... making table referencing more robust, you either need to update SQL.REQUEST or the list functions like DSUM in order to handle complex criteria more cleanly than the SUMPRODUCT and ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ijsm9eYeYLzs9Ir1ExwKvpFE8Ew\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ijsm9eYeYLzs9Ir1ExwKvpFE8Ew\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ijsm9eYeYLzs9Ir1ExwKvpFE8Ew\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Ijsm9eYeYLzs9Ir1ExwKvpFE8Ew\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=2346" target="_blank" >PHPExcel - View Issue #2346: Implement more Excel calculation ...</a></span>');
document.write('<div>If there is a priority list, could I add SUMPRODUCT to it? I know it\'s not the easiest function to implement (because of it\'s widely varying list of arguments), but it\'d be a great ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/xoH-8RqWQafEF2QzpmbvMibHua0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/xoH-8RqWQafEF2QzpmbvMibHua0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/xoH-8RqWQafEF2QzpmbvMibHua0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/xoH-8RqWQafEF2QzpmbvMibHua0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225774.aspx" target="_blank" >WorksheetFunction Object Members</a></span>');
document.write('<div>SumProduct: Multiplies corresponding components in the given arrays, and returns the sum of those products. SumSq: Returns the sum of the squares of the arguments.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VKgZjUGL0v-4SViSqkubTYHd5CA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VKgZjUGL0v-4SViSqkubTYHd5CA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VKgZjUGL0v-4SViSqkubTYHd5CA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VKgZjUGL0v-4SViSqkubTYHd5CA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.windowsclient.net/wisecarver/archive/2009/09/23/wow-excel-q-a-article-overload.aspx" target="_blank" >Wow, Excel Q\/A article overload - No1 Microsoft Fan</a></span>');
document.write('<div>=SUMPRODUCT((MOD(ROW(A1:A250)-ROW(A1),2)=0)*(A1:A250)) MrExcel provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/gDkhaWgMaMV9ZJArkYhKP0wx9uY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/gDkhaWgMaMV9ZJArkYhKP0wx9uY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/gDkhaWgMaMV9ZJArkYhKP0wx9uY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/gDkhaWgMaMV9ZJArkYhKP0wx9uY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://blogs.windowsclient.net/wisecarver/archive/2009/09.aspx" target="_blank" >September 2009 - Posts - No1 Microsoft Fan</a></span>');
document.write('<div>=SUMPRODUCT((MOD(ROW(A1:A250)-ROW(A1),2)=0)*(A1:A250)) MrExcel provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/JTmrtMWMGGlGvqh3hjCq_j-9CBQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/JTmrtMWMGGlGvqh3hjCq_j-9CBQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/JTmrtMWMGGlGvqh3hjCq_j-9CBQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/JTmrtMWMGGlGvqh3hjCq_j-9CBQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/5c55504f-39f4-4f7b-9167-b1521e4be71e" target="_blank" >Calculated Measure - Unique Requirement</a></span>');
document.write('<div>9000: 90: 0.1: B: 120: 480: 4: 0.4: C: 140: 700: 5: 0.13: D: 50: 100: 2: 0.16: E: 70: 350: 5: 0.28: 480: 10630: 22.14583: 0.17: Wrong Value: 1807.1: 10630 * 0.17: Right Value: 1297: SUMPRODUCT(C4:C8,E4:E8)\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UOiPlVCtJ0saGv8ot4--D-xfgh4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UOiPlVCtJ0saGv8ot4--D-xfgh4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/UOiPlVCtJ0saGv8ot4--D-xfgh4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/UOiPlVCtJ0saGv8ot4--D-xfgh4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheetfunction_methods(office.11).aspx" target="_blank" >WorksheetFunction Methods (Microsoft.Office.Interop.Excel)</a></span>');
document.write('<div>SumProduct: For information about this worksheet function, see the Help for worksheet functions on Office Online. SumSq\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/uoSxJVHPJWr-PLmSp20DI3q6X0M\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/uoSxJVHPJWr-PLmSp20DI3q6X0M\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/uoSxJVHPJWr-PLmSp20DI3q6X0M\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/uoSxJVHPJWr-PLmSp20DI3q6X0M\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://social.msdn.microsoft.com/forums/en-US/searchserverdevelopersandcustomization/thread/42427499-7282-459c-99f7-16d2309e13d2/" target="_blank" >conditional sum wizard returning incorrect zero</a></span>');
document.write('<div>Sumproduct I cannot attached the sheet due to company confidentiality requirements but I am desperate for assistance becasue if I can get this to work it will save an incredible ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/SFMsFB_86bWAstD0_FrKb8JeM-U\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/SFMsFB_86bWAstD0_FrKb8JeM-U\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/SFMsFB_86bWAstD0_FrKb8JeM-U\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/SFMsFB_86bWAstD0_FrKb8JeM-U\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheetfunction_members(office.11).aspx" target="_blank" >WorksheetFunction Members (Microsoft.Office.Interop.Excel)</a></span>');
document.write('<div>SumProduct: For information about this worksheet function, see the Help for worksheet functions on Office Online. SumSq: For information about this worksheet ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/79yNTnVSJ7EDu5Cv5ZKqk13gh8s\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/79yNTnVSJ7EDu5Cv5ZKqk13gh8s\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/79yNTnVSJ7EDu5Cv5ZKqk13gh8s\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/79yNTnVSJ7EDu5Cv5ZKqk13gh8s\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/5489e09f-a1d8-425e-9034-e640d1506feb" target="_blank" >Need assistance with the conditional sum wizard returning incorrect ...</a></span>');
document.write('<div>Sumproduct I cannot attached the sheet due to company confidentiality requirements but I am desperate for assistance because if I can get this to work it will save an incredible ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/v83tZbxguQ_85SNBq9Z0QN0ZWqE\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/v83tZbxguQ_85SNBq9Z0QN0ZWqE\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/v83tZbxguQ_85SNBq9Z0QN0ZWqE\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/v83tZbxguQ_85SNBq9Z0QN0ZWqE\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/pTwW"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');