Use Msdn to search the Web.http://feedproxy.google.com/~r/microsoft/pTwW/~3/AGxjYm1-RoA/aa730921.aspxSUMPRODUCT 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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/AGxjYm1-RoA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa730921.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/0_Cpknhfcw0/bb239778.aspxMultiplies corresponding components in the given arrays, and returns the sum of those products. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/0_Cpknhfcw0" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb239778.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/pfMDiVCe-vM/Search Forums: Search Visual Basic for Applications (VBA) Forum Search All Microsoft ISV Community Center Forums Search All MSDN Forums <p><a href="http://feedads.g.doubleclick.net/~a/oq1G2iqZwyZMuQBv3ng30Q4Bczk/0/da"><img src="http://feedads.g.doubleclick.net/~a/oq1G2iqZwyZMuQBv3ng30Q4Bczk/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/oq1G2iqZwyZMuQBv3ng30Q4Bczk/1/da"><img src="http://feedads.g.doubleclick.net/~a/oq1G2iqZwyZMuQBv3ng30Q4Bczk/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/pfMDiVCe-vM" height="1" width="1"/>http://social.msdn.microsoft.com/forums/en-US/isvvba/thread/effcdc61-7458-4bed-bc0e-ddc0c3c6e9df/http://feedproxy.google.com/~r/microsoft/pTwW/~3/xsPLSnZXX40/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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/xsPLSnZXX40" height="1" width="1"/>http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/b0314e6f-408f-4bca-bde8-819d9e826c86/http://feedproxy.google.com/~r/microsoft/pTwW/~3/t8P9m9Gddv8/microsoft.office.interop.excel.worksheetfunction.sumproduct(office.11).aspxFor information about this worksheet function, see the Help for worksheet functions on Office Online. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/t8P9m9Gddv8" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheetfunction.sumproduct(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/p0xx13Cdxas/dd789430.aspxAddLine "SumX2PY2:", obj.SumX2PY2(varCol1, varCol2) AddLine "SumSQ:", obj.SumSQ(varCol1) AddLine "SumProduct:", obj.SumProduct(varCol1, varCol2) AddLine "StDev ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/p0xx13Cdxas" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd789430.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/Pbb2cE4Urow/microsoft.office.interop.excel.iworksheetfunction.sumproduct(office.11).aspxThis method supports the .NET Framework infrastructure and is not intended to be used directly from your code. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/Pbb2cE4Urow" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.iworksheetfunction.sumproduct(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/yNqi3jYYQx0/Search Forums: Search Visual Basic for Applications (VBA) Forum Search All Microsoft ISV Community Center Forums Search All MSDN Forums <p><a href="http://feedads.g.doubleclick.net/~a/AXeqalvmeFoSlgLXlsuU-1-VC5E/0/da"><img src="http://feedads.g.doubleclick.net/~a/AXeqalvmeFoSlgLXlsuU-1-VC5E/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/AXeqalvmeFoSlgLXlsuU-1-VC5E/1/da"><img src="http://feedads.g.doubleclick.net/~a/AXeqalvmeFoSlgLXlsuU-1-VC5E/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/yNqi3jYYQx0" height="1" width="1"/>http://social.msdn.microsoft.com/forums/en-US/isvvba/thread/dc3a7a33-c72d-4861-879d-a46170ad7237/http://feedproxy.google.com/~r/microsoft/pTwW/~3/0HUDpazArw0/109211A weighted average differs from an average in that a weighted average returns a ... =SUMPRODUCT(A2:A3,B2:B3)/SUM(B2:B3) <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/0HUDpazArw0" height="1" width="1"/>http://support.microsoft.com/kb/109211http://feedproxy.google.com/~r/microsoft/pTwW/~3/vmVYTFPvrZ8/214049A weighted average differs from an average in that a weighted average returns a number ... =SUMPRODUCT(A2:A3,B2:B3)/SUM(B2:B3) <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/vmVYTFPvrZ8" height="1" width="1"/>http://support.microsoft.com/kb/214049http://feedproxy.google.com/~r/microsoft/pTwW/~3/61d48QOFKg0/Search Forums: Search Visual Basic for Applications (VBA) Forum Search All Microsoft ISV Community Center Forums Search All MSDN Forums <p><a href="http://feedads.g.doubleclick.net/~a/kTUkC1Ah2PO7wMHzqsv8LoZL8BI/0/da"><img src="http://feedads.g.doubleclick.net/~a/kTUkC1Ah2PO7wMHzqsv8LoZL8BI/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/kTUkC1Ah2PO7wMHzqsv8LoZL8BI/1/da"><img src="http://feedads.g.doubleclick.net/~a/kTUkC1Ah2PO7wMHzqsv8LoZL8BI/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/61d48QOFKg0" height="1" width="1"/>http://social.msdn.microsoft.com/forums/en-US/isvvba/thread/a2cec50d-eb6d-41da-bf32-caca08fdecdd/http://feedproxy.google.com/~r/microsoft/pTwW/~3/HLwyEU5L90Q/using-excel-to-optimize-a-network-problem.aspxSUMPRODUCT 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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/HLwyEU5L90Q" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2008/12/03/using-excel-to-optimize-a-network-problem.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/cVZaXGdE2xg/adding-every-other-cell-in-a-column.aspx=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! <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/cVZaXGdE2xg" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2009/09/24/adding-every-other-cell-in-a-column.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/FqcJZQk6Km4/192377A weighted average differs from an average in that a weighted average returns a ... =SUMPRODUCT(A2:A3,B2:B3)/SUM(B2:B3) <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/FqcJZQk6Km4" height="1" width="1"/>http://support.microsoft.com/kb/192377http://feedproxy.google.com/~r/microsoft/pTwW/~3/YDZrpwjgE_E/132221A1: =SUMPRODUCT(A2:BT77) ... This behavior occurs because in Microsoft Excel, the maximum array size is 5458 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/YDZrpwjgE_E" height="1" width="1"/>http://support.microsoft.com/kb/132221http://feedproxy.google.com/~r/microsoft/pTwW/~3/kSGNRzfICnM/166342SUMPRODUCT() 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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/kSGNRzfICnM" height="1" width="1"/>http://support.microsoft.com/kb/166342http://feedproxy.google.com/~r/microsoft/pTwW/~3/vJQ-1bWxUw4/View.aspxSecondly, SUMPRODUCT() isn't yet implemented in the calculation engine, so the result of this formula cannot be calculated internally by PHPExcel. <p><a href="http://feedads.g.doubleclick.net/~a/7aLU7gBCOED1rvvYRVMPExGGr_M/0/da"><img src="http://feedads.g.doubleclick.net/~a/7aLU7gBCOED1rvvYRVMPExGGr_M/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/7aLU7gBCOED1rvvYRVMPExGGr_M/1/da"><img src="http://feedads.g.doubleclick.net/~a/7aLU7gBCOED1rvvYRVMPExGGr_M/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/vJQ-1bWxUw4" height="1" width="1"/>http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=74069http://feedproxy.google.com/~r/microsoft/pTwW/~3/giv_3wBS6eM/538875.aspxKanwal - You can use a normally entered Sumproduct formula which will evaluate just fine: =SUMPRODUCT(--($H$4:H715>=$AG$1),--($I$4:I715<>"Swi")) <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/giv_3wBS6eM" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2006/02/24/538875.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/n5v3vofEjpo/701779.aspx=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. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/n5v3vofEjpo" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2006/08/15/701779.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/wRhuw6dKN8A/en-gbSUMPRODUCT is a quick way of multiplying all the numbers in one column by the corresponding number in another column and totalling the results. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/wRhuw6dKN8A" height="1" width="1"/>http://support.microsoft.com/kb/841341/en-gbhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/UyU5AFeuI60/aa221655(office.11).aspxSumProduct. SumSq. SumX2MY2. SumX2PY2. SumXMY2. Syd. Tanh. TDist. Text. TInv. Transpose. Trend. Trim. TrimMean. TTest. USDollar. Var. VarP. Vdb. VLookup. Weekday. Weibull. ZTest <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/UyU5AFeuI60" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa221655(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/qs93jAE8LzE/aa178231(SQL.80).aspxSumProduct: SumSq: SumX2MY2: SumX2PY2: SumXMY2: Syd: Tanh: TDist: Text: TInv: Transpose *Trend: Trim: TrimMean: TTest: USDollar: Var: VarP: Vdb *VLookup: Weekday: Weibull: ZTest <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/qs93jAE8LzE" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa178231(SQL.80).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/KXXcg8vFWZI/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers.aspx=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]) <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/KXXcg8vFWZI" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/Kk4EwpzoUMI/bb211378.aspxSumProduct. SumSq. SumX2MY2. SumX2PY2. SumXMY2. Syd. Tanh. TBillEq. TBillPrice. TBillYield. TDist. Text. TInv. Transpose. Trend. Trim. TrimMean. TTest. USDollar. Var. VarP. Vdb. VLookup <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/Kk4EwpzoUMI" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb211378.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/DvqbQahkY9c/the-dislpayformat-om.aspxor 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) <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/DvqbQahkY9c" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2009/08/13/the-dislpayformat-om.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/c2aHmEc5s_o/microsoft.office.interop.excel.iworksheetfunction_methods(office.11).aspxExcel Primary Interop Assembly Reference ... SumProduct Method SumSq Method SumX2MY2 Method SumX2PY2 Method SumXMY2 Method <p><a href="http://feedads.g.doubleclick.net/~a/IEUx-OXrwQYfW9lDGnjLxCS_-Q4/0/da"><img src="http://feedads.g.doubleclick.net/~a/IEUx-OXrwQYfW9lDGnjLxCS_-Q4/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/IEUx-OXrwQYfW9lDGnjLxCS_-Q4/1/da"><img src="http://feedads.g.doubleclick.net/~a/IEUx-OXrwQYfW9lDGnjLxCS_-Q4/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/c2aHmEc5s_o" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.iworksheetfunction_methods(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/Pe3WvpUumfw/aa272490(office.10).aspxSumProduct. 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 <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/Pe3WvpUumfw" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa272490(office.10).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/K8sgz0cCeLw/The following formula gives the sum in the A column: =SUMPRODUCT(--(A2:A6=10),--(C2:C6="Brand"),A2:A6) The following forumla gives the numbers of records: =SUMPRODUCT(--(A2:A6=10 ... <p><a href="http://feedads.g.doubleclick.net/~a/Mz6HLdeWOm1nwNt6BmiXQE8C5nE/0/da"><img src="http://feedads.g.doubleclick.net/~a/Mz6HLdeWOm1nwNt6BmiXQE8C5nE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/Mz6HLdeWOm1nwNt6BmiXQE8C5nE/1/da"><img src="http://feedads.g.doubleclick.net/~a/Mz6HLdeWOm1nwNt6BmiXQE8C5nE/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/K8sgz0cCeLw" height="1" width="1"/>http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/8ef3d604-71eb-483c-89c1-07ea5a5543fc/http://feedproxy.google.com/~r/microsoft/pTwW/~3/Avvwo630q94/writing-custom-excel-worksheet-functions-in-c_2D00_sharp.aspx=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..... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/Avvwo630q94" height="1" width="1"/>http://blogs.msdn.com/gabhan_berry/archive/2008/04/07/writing-custom-excel-worksheet-functions-in-c_2D00_sharp.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/WYkr0TQ2pYM/483661.aspx3D ranges for SUMPRODUCT has not changed from Excel 2003. Jean, Gary, Tianwei – what is the scenario you have in mind when you say “dynamic ranges”? <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/WYkr0TQ2pYM" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2005/10/21/483661.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/mXH1SiX5r-E/dd906358.aspxsumproduct-params = "(" (expression / (argument 1*254("," argument))) ")" sumsq-params = "(" (expression / (argument 1*254("," argument))) ")" sumx2my2-params = "(" argument ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/mXH1SiX5r-E" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd906358.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/OVhoF23Tljg/479713.aspxI'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"))]. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/OVhoF23Tljg" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2005/10/11/479713.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/D1p9yUAEqyA/dd904817.aspxSUMPRODUCT. sumproduct-params = val, *29(val) 0x00E5 . SINH. sinh-params = val. 0x00E6 . COSH. cosh-params = val. 0x00E7 . TANH. tanh-params = val <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/D1p9yUAEqyA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd904817.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/0lcXQNveWJk/69204... Statistic Financial Mathematical ----- @DGET @D360 @ISRANGE @COORD @STDS @VDB @SUMPRODUCT ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/0lcXQNveWJk" height="1" width="1"/>http://support.microsoft.com/kb/69204http://feedproxy.google.com/~r/microsoft/pTwW/~3/VFdtzSK13ds/aa168292(office.11).aspxStatistical functions such as BetaDist, BinomDist, ChiTest, ChiInv, LogNormDist, NegBinomDist, Pearson, SumProduct, SumSq, TDist, TTest, Var, VarP, and more. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/VFdtzSK13ds" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa168292(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/L-R0L3liou4/when-a-number-is-not-a-number.aspx=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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/L-R0L3liou4" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2009/01/19/when-a-number-is-not-a-number.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/FBY9vvuP81I/dd948579.aspxSUMPRODUCT. sumproduct-params = val *254(val) 0x00E5 . SINH. sinh-params = val. 0x00E6 . COSH. cosh-params = val. 0x00E7 . TANH. tanh-params = val <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/FBY9vvuP81I" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/dd948579.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/dNC0Mt2DIpc/bb225774.aspxSumProduct: Multiplies corresponding components in the given arrays, and returns the sum of those products. SumSq: Returns the sum of the squares of the arguments. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/dNC0Mt2DIpc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb225774.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/qfpnst5nEdI/analyzing-data-functions-of-pivottables.aspxBoth 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: <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/qfpnst5nEdI" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2009/03/23/analyzing-data-functions-of-pivottables.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/6nxPVENz9c4/microsoft.office.interop.excel.iworksheetfunction_members(office.11).aspxThe following tables list the members exposed by the ... SumProduct SumSq SumX2MY2 SumX2PY2 SumXMY2 Syd Tanh TDist Text ThaiDayOfWeek <p><a href="http://feedads.g.doubleclick.net/~a/dHGyAr2BSzG_ybNLO2ieV_gzcKw/0/da"><img src="http://feedads.g.doubleclick.net/~a/dHGyAr2BSzG_ybNLO2ieV_gzcKw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/dHGyAr2BSzG_ybNLO2ieV_gzcKw/1/da"><img src="http://feedads.g.doubleclick.net/~a/dHGyAr2BSzG_ybNLO2ieV_gzcKw/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/6nxPVENz9c4" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.iworksheetfunction_members(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/Dqzv6ypved0/486604.aspx=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 <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/Dqzv6ypved0" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2005/10/28/486604.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/BXjUS5gZQXQ/=SUMPRODUCT(--($F$3:$R$23=$B2))>1 Set the pattern to be Red Add another condition with the formula =SUMPRODUCT(--($F$3:$R$23=$B2))=1 Set the pattern to Green. <p><a href="http://feedads.g.doubleclick.net/~a/ATxn-VVjOnC0ct0BgjMNOIJ0vZs/0/da"><img src="http://feedads.g.doubleclick.net/~a/ATxn-VVjOnC0ct0BgjMNOIJ0vZs/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/ATxn-VVjOnC0ct0BgjMNOIJ0vZs/1/da"><img src="http://feedads.g.doubleclick.net/~a/ATxn-VVjOnC0ct0BgjMNOIJ0vZs/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/BXjUS5gZQXQ" height="1" width="1"/>http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/e789e109-8f99-4644-9a0c-ad2f2cbf3976/http://feedproxy.google.com/~r/microsoft/pTwW/~3/9NXC4e6fb2w/aa537184(office.11).aspxStatistical functions such as BetaDist, BinomDist, ChiTest, ChiInv, LogNormDist, NegBinomDist, Pearson, SumProduct, SumSq, TDist, TTest, Var, VarP, and more. <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/9NXC4e6fb2w" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa537184(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/TRiLBKBDaok/View.aspxIf 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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/TRiLBKBDaok" height="1" width="1"/>http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=2346http://feedproxy.google.com/~r/microsoft/pTwW/~3/psHZIGEnLmM/270933.aspx=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 ... <p><a href="http://feedads.g.doubleclick.net/~a/pfD_lQmXEpcoTAluWFoj65wv4Pw/0/da"><img src="http://feedads.g.doubleclick.net/~a/pfD_lQmXEpcoTAluWFoj65wv4Pw/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/pfD_lQmXEpcoTAluWFoj65wv4Pw/1/da"><img src="http://feedads.g.doubleclick.net/~a/pfD_lQmXEpcoTAluWFoj65wv4Pw/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/psHZIGEnLmM" height="1" width="1"/>http://blogs.windowsclient.net/270933.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/EywvXQ7ML0M/Formula: =SUMPRODUCT((A1:A10<>"")/(COUNTIF(A1:A10,A1:A10&""))) Formula: =SUMPRODUCT((A1:A10<>"")/(COUNTIF(A1:A10,A1:A10)+(A1:A10=""))) or with VBA... <p><a href="http://feedads.g.doubleclick.net/~a/XHWTAjJp9LR-IRXMKhqUDpF81r8/0/da"><img src="http://feedads.g.doubleclick.net/~a/XHWTAjJp9LR-IRXMKhqUDpF81r8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/XHWTAjJp9LR-IRXMKhqUDpF81r8/1/da"><img src="http://feedads.g.doubleclick.net/~a/XHWTAjJp9LR-IRXMKhqUDpF81r8/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/EywvXQ7ML0M" height="1" width="1"/>http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/aa36f0b9-1835-4af1-8bd2-e7850df668c1/http://feedproxy.google.com/~r/microsoft/pTwW/~3/gzzL33etcKs/... to vba and i am require to sum up the number of calls received per week and have to prompt start and end date(Eg. 2 jan 06 to 08 jan 06) instead of using this formula =SUMPRODUCT <p><a href="http://feedads.g.doubleclick.net/~a/K8Bopm-DCHX6xp_JGoLWoeXcwsU/0/da"><img src="http://feedads.g.doubleclick.net/~a/K8Bopm-DCHX6xp_JGoLWoeXcwsU/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/K8Bopm-DCHX6xp_JGoLWoeXcwsU/1/da"><img src="http://feedads.g.doubleclick.net/~a/K8Bopm-DCHX6xp_JGoLWoeXcwsU/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/gzzL33etcKs" height="1" width="1"/>http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/c3d2903e-6a57-4151-a502-f938d380609d/http://feedproxy.google.com/~r/microsoft/pTwW/~3/KeXXCdnZRG8/microsoft.office.interop.excel.worksheetfunction_methods(office.11).aspxSumProduct: For information about this worksheet function, see the Help for worksheet functions on Office Online. SumSq <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/KeXXCdnZRG8" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.worksheetfunction_methods(office.11).aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/peAi4OusUyE/596605.aspx... 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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/peAi4OusUyE" height="1" width="1"/>http://blogs.msdn.com/excel/archive/2006/05/12/596605.aspxhttp://feedproxy.google.com/~r/microsoft/pTwW/~3/o8pVamH7ODU/09.aspx=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 ... <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/> <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><img src="http://feeds.feedburner.com/~r/microsoft/pTwW/~4/o8pVamH7ODU" height="1" width="1"/>http://blogs.windowsclient.net/wisecarver/archive/2009/09.aspx