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.
Bookmarks