å¯ä»¥çï¼ä¾å¦å¾æ示ï¼æå°±æç §å¾æ¥è§£è¯´
a1ï¼d4å°±ä¸è¯´äºï¼æºæ°æ®
a6ï¼d9ä¸ºè¾ å©æ°æ®ï¼ååºäºa1ï¼d4çé¢è²ã
æä½å¦ä¸ï¼
éä¸a6ï¼å®ä¹å称ââè¾å ¥å称ï¼å¤æé¢è²ï¼ï¼å¼ç¨ä½ç½®ï¼=get.cell(24,a1:d4)ï¼ââç¡®å®ã
å¨a6ä¸è¾å ¥ï¼ï¼å¤æé¢è²ï¼ ä¸æå¡«å ï¼åå³æå¡«å ï¼å®äºå°±æ¾ç¤ºå¦å¾æ°åã
f1ä¸è¾å ¥ï¼ç ï¼f2ä¸è¾å ¥3 è¿ä¸¤ä¸ªåå æ ¼ä½ä¸ºè¾ å©ã
a11ä¸è¾å ¥å ¬å¼ï¼=SUMPRODUCT((A1:D4=F1)*(A6:D9=F2))
over