Hi all
I have two formula but one have result, one have result = 0. I can;t find out the mistake of wrong formula:
formula have result =+SUMPRODUCT((('ky1'!$E$2:$E$9999="0101")*(LEFT('ky1'!$A$2:$A$9999;6)="G03654"))*('ky1'!$F$2:$F$9999:'ky1'!$G$2:$G$9999))
formula result = 0: =+SUMPRODUCT((('ky3'!$D$2:$D$9999="0101")*(LEFT('ky3'!$A$2:$A$9999;6)="G01014"))*('ky3'!$E$2:$E$9999:'ky3'!$F$2:$F$9999))
Please help me, thanks./.
I have two formula but one have result, one have result = 0. I can;t find out the mistake of wrong formula:
formula have result =+SUMPRODUCT((('ky1'!$E$2:$E$9999="0101")*(LEFT('ky1'!$A$2:$A$9999;6)="G03654"))*('ky1'!$F$2:$F$9999:'ky1'!$G$2:$G$9999))
formula result = 0: =+SUMPRODUCT((('ky3'!$D$2:$D$9999="0101")*(LEFT('ky3'!$A$2:$A$9999;6)="G01014"))*('ky3'!$E$2:$E$9999:'ky3'!$F$2:$F$9999))
Please help me, thanks./.