Thread: How to use SUMPRODUCT in VBA (further query)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Robert is offline
external usenet poster
  
Posts: 113
Default How to use SUMPRODUCT in VBA (further query)
Could Madiya or Toppers advise as to how and where the following code by
Toppers should be placed. What is meant by ("d1").Thank you.

Range("d1") =
Evaluate("SUMPRODUCT(--(ALVXXL01!$B$2:$B$65536=A5),--(ALVXXL01!$K$2:$K$65536=""MMV3""),--(ALVXXL01!$P$2:$P$655360),--(ALVXXL01!$P$2:$P$65536))")

--
Robert
Reply With QuoteReply With Quote