再次请教下,假如A至E列的数据太多,一个表格不够放,在表格sheet1!表格和sheet2!都有,该怎么引用公式呢?
excel2007
æ±åå ¬å¼ï¼=SUMPRODUCT((B$2:B$10=E2)*(A$2:A$10>=F2)*(A$2:A$10<=G2)*C$2:C$10)
è§å¾
Aåæ¥æï¼Bå车å·ï¼Cåéç¨ï¼ Eåæ¥æ¾è½¦å·ï¼Fåå¼å§æ¶é´ï¼Gåç»ææ¶é´ï¼Håæ»éç¨
追é®å次请æï¼å å ¥Aè³Cåçæ°æ®ä¸ä¸ªè¡¨æ ¼ä¸å¤æ¾ï¼å¨sheet1ï¼åsheet2ï¼è¡¨æ ¼åæ¶ææ°æ®ï¼è¯¥æä¹å¼ç¨è¯¥å ¬å¼å¢ï¼
追ç楼主æ¯2007åï¼
100å¤ä¸è¡é½ä¸å¤ç¨çï¼
å¦æ100å¤ä¸è¡é½ä¸å¤ç¨çè¯ï¼å»ºè®®æ¥¼ä¸»æ¹æ°æ®åºå§ãä¸ç¶æçè·ä¸ä¸å§ã