ML089

¦^´_ 30# starry1314

¬O§_¬O³o¼Ë¡A¨ú²Ä2½X»P²Ä5½X¤ñ¸û
D3 =SUMPRODUCT(1/COUNTIF(rng,rng)*(MMULT((MID(rng,{2,5},1)=MID(D$2,{1,2},1))*1,{1;1})=2))       
¥k©Ô       
       
J3 =SUM(D3:I3)       
K3 =SUMIF(D2:I2,"?V",D3:I3)

ML089

¦^´_ 32# starry1314

¨ú²Ä2½X»P²Ä5½X¤ñ¸û
D3 =SUMPRODUCT(1/COUNTIF(rng,rng)*(MMULT((MID(rng,{2,5},1)=MID(D$2,{1,2},1))*1,{1;1})=2))        
¥k©Ô        
        
J3 =SUM(D3:I3)        
K3 =SUMIF(D2:I2,"?V",D3:I3)

ML089

¦^´_ 35# starry1314


    =SUMPRODUCT(1/COUNTIF(rng,rng)) - COUNTIF(rng," ")

ML089

¦]¥Ø«e10­Ó¤H¤º¥u­n¦³¤@­Ó¤H¬O¤£­n­pºâªº¸Ü´N·|©T©w¥X²{¤Q­ÓªÅ¥Õ­È
=SUMPRODUCT(1/COUNTIF(rng,rng)) - COUNTIF(rng," ")  /10  §Ú¥Ø«e¬O³o¼Ë¨Ï¥Î¥i¥¿½T­pºâ,¦ý·Q½Ð°Ý¦pªG¹J¨ì¤£©T©wªÅ¥Õ®æ©O?

§ï¬°
=SUMPRODUCT(1/COUNTIF(rng,rng)) - (COUNTIF(rng," ")>0)