How to transform the code below into VBA Code (or another method)?
IF(COUNTIF(Data!$1:$1,A2)=0,0,COUNTIF(Data!$1:$1,B1))+
IF(COUNTIF(Data!$2:$2,A2)=0,0,COUNTIF(Data!$2:$2,B1))+
IF(COUNTIF(Data!$3:$3,A2)=0,0,COUNTIF(Data!$3:$3,B1))+
.
.
.
IF(COUNTIF(Data!$10000:$10000,A2)=0,0,COUNTIF(Data!$10000:$10000,B1))
Thanks.
IF(COUNTIF(Data!$1:$1,A2)=0,0,COUNTIF(Data!$1:$1,B1))+
IF(COUNTIF(Data!$2:$2,A2)=0,0,COUNTIF(Data!$2:$2,B1))+
IF(COUNTIF(Data!$3:$3,A2)=0,0,COUNTIF(Data!$3:$3,B1))+
.
.
.
IF(COUNTIF(Data!$10000:$10000,A2)=0,0,COUNTIF(Data!$10000:$10000,B1))
Thanks.
