Thread: Sumproduct instead of SumifS in VBA (application.sumproduct)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Majken Bilslev-Jensen Majken Bilslev-Jensen is offline
external usenet poster
  
Posts: 2
Default Sumproduct instead of SumifS in VBA (application.sumproduct)
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!

Reply With QuoteReply With Quote