The following line of code gives me a #VALUE!
Cells(R, C).Value = Evaluate("SUMPRODUCT(--(" &
RngP5.Address(External:=True) & "=" & Cr1.Address & "), --(" &
RngP1.Address(External:=True) & ">=" & Cr7.Address & "), --(" &
RngP1.Address(External:=True) & "<=" & Cr8.Address & _
"), --(" & RngP3.Address(External:=True) & "=" & Cr3.Address & "), --(" &
RngP2.Address(External:=True) & "=" & Cr2.Address & "))")

But if I change this from (just the first few char and rest as same)
Cells(R, C).Value = Evaluate("SUMPRODUCT
to
Cells(R, C).Formula = ("=SUMPRODUCT
it puts the formula in the worksheet and I get the desired result.

What is this???
--
Baapi