Hi All,

Hope someone can help me. Attached is a sample excel file.

Mapping Calc.xlsx

Im having a difficulty in getting the value from sheet 2 column B because it contains spaces and it cant count the value of more than one field unit.
I tried using the below code but it does not grab the value because of spaces.

=SUMPRODUCT(('Sheet2'!B:B="DS")*('Sheet2'!A:A="successful")

Hope someone can either correct my formula in sheet 2 and sheet 1. :-)

Kind Regards,
Mark.