Posted to microsoft.public.excel.programming

joeu2004

external usenet poster

Posts: 2,059

Sumproduct instead of SumifS in VBA (application.sumproduct)

On Dec 30, 4:08*am, Majken Bilslev-Jensen
wrote:
The following code does not work:

Application.SumProduct((Application.Index(holdings .Range("holdings"),
0, 1) = "ff") * (Application.Index(holdings.Range("holdings"), 0, 5) =
"gg") * Application.Index(holdings.Range("holdings"), 0, 3))

Try this:

Evaluate("SUMPRODUCT((INDEX(Holdings,0,1)="ff")*(I NDEX(Holdings,
0,5)="gg"),
INDEX(Holdings,0,3)")

Note: Enter the entire formula on __one__ VBA line or use apply VBA
line continuation syntax appropriately.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 -- SUMIFS v SUMPRODUCT	MurrayBarn	Excel Worksheet Functions	4	June 12th 09 02:53 PM
Are SUMIFS and SUMPRODUCT the same?	wx4usa	Excel Discussion (Misc queries)	3	December 8th 08 10:22 AM
Application.Worksheetfunction.Sumproduct	Tetsuya Oguma	Excel Programming	4	July 16th 08 01:43 PM
application.sumproduct help please	Gareth[_3_]	Excel Programming	6	August 22nd 05 12:30 AM
application.sumproduct help please	Gareth[_3_]	Excel Programming	0	August 21st 05 01:50 PM

All times are GMT +1. The time now is 06:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us