How to use SUMPRODUCT in VBA (further query)

[Guest]

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$65536>0),--(ALVXXL01!$P$2:$P$65536))")

 

[Bob Phillips]

It should be placed in a macro and it will then work when you run the macro.

D1 refers to the cell that the value resulting from the formula will be
placed within.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Thank you Bob for the explanation.
--
Robert

It should be placed in a macro and it will then work when you run the macro.

D1 refers to the cell that the value resulting from the formula will be
placed within.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)