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

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)

"Robert" wrote in message
...
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

Thank you Bob for the explanation.
--
Robert


"Bob Phillips" wrote:

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)

"Robert" wrote in message
...
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