A B
CRM1 0.84 <=0.4
CRM1 0.818 <=0.5 & >0.4
CRM1 1.295 <=0.6 & >0.5
CRM1 1.479 <=0.7 & >0.6
CRM1 0.61 <=1.0 & >0.7
CRM1 1.436 >1.0
CRM1 0.962
CRM2 1.179
CRM2 0.74
CRM2 0.579
CRM2 0.812
CRM2 0.772
CRM2 0.635
CRM1 0.577
CRM2 0.32
CRM1 0.36
CRM1 0.45
CRM2 0.51
CRM2 0.65
求先满足CRM1,然后按第三列的条件统计第二列的数据
å¦å¾å®ææ°æ®ï¼
ABåæ¯åå§æ°æ®
C2ä¸ºå¿ å®æ¡ä»¶ï¼D2ï¼E7为ç¹å®æ¡ä»¶
F2å
¬å¼å¯ç»è®¡ä¸ªæ°
=SUMPRODUCT((A$1:A$100=C$2)*(B$1:B$100>D2)*(B$1:B$100<=E2))
ä¸æå°Eåæ¡ä»¶æ«å°¾
é件å¯åèï¼æé®è ä¸è½½ä¸éè¦è´¢å¯å¼