=SUM(IF(A2='[OCR Blue.xls]OCR Contract r20'!$D:$D,'[OCR Blue.xls]OCR Contract r20'!$AA:$AA))
I am tyring to look for the item in A2 and go to another sheet and look for that value in column "D" and then sum the items in the corresponding column"AA:AA". I am getting the error message #NUM. Any help would be appreciated.
I am tyring to look for the item in A2 and go to another sheet and look for that value in column "D" and then sum the items in the corresponding column"AA:AA". I am getting the error message #NUM. Any help would be appreciated.