Hi all,
While updating a worsheet A with new data (same headers), the WorkSheet B containning the formulas : =SUMPRODUCT(--('WorkSheetA'!$BG$2:$BG$10000="Pending"),--('WorkSheetA'!$BF$2:$BF$10000='WorkSheetB'!A5)) gives #N/A as result in all the cells.
In the meanwhile, when I test, in the same formulat, to change the number of the colunm BF to BG, It gives a result (but not the one i need of course)
My question is : is it possbile that the formulat does not recognize the column BF?
Thank you for your lights
Zerhiab
While updating a worsheet A with new data (same headers), the WorkSheet B containning the formulas : =SUMPRODUCT(--('WorkSheetA'!$BG$2:$BG$10000="Pending"),--('WorkSheetA'!$BF$2:$BF$10000='WorkSheetB'!A5)) gives #N/A as result in all the cells.
In the meanwhile, when I test, in the same formulat, to change the number of the colunm BF to BG, It gives a result (but not the one i need of course)
My question is : is it possbile that the formulat does not recognize the column BF?
Thank you for your lights
Zerhiab