Sumproduct instead of SumifS in VBA (application.sumproduct)
Try application.WorksheetFunction.SumProduct
On Dec 30, 12:08*pm, Majken Bilslev-Jensen
wrote:
Hi all,
I have a problem in VBA using application.sumproduct.
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))
Can anyone help me? Thanks heaps!
|