Hello,

I am using the below formula:

=SUMPRODUCT((SUBSTITUTE(A1:A10,"P","")="N001")*(B1 :B10=--"02/06/06")*(C1:C10))

but am getting #VALUE! returned in the cell as I am trying to return Text
not numbers from the Column C cells. Does anyone know a way round this so I
can return the text?

Thanks,
Ross