(Solved)When a column is not recognized by a formulat

[zeriab]

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

 

[GlennUK]

Have you made sure that none of the entries in the range 'WorkSheetA'!$BF$2:$BF$10000 has the result #N/A?

 

[zeriab]

You re right

Thank you very much

Zerhiab

 

[GlennUK]

My pleasure!!