- ©«¤l
- 14
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 55
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-7
- ³Ì«áµn¿ý
- 2013-1-22
|
¤W¹Ï³oÓ¤½¦¡¦³¿ìªk²¤Æ¶Ü¡H
¨ä¹ê¨Ï¥Îªº¤½¦¡³£®t¤£¦h¡A¦ý¬O¦]¬°¤£ª¾¹D«ç»ò²¤Æ¡A©Ò¥HÅý¤½¦¡Åܫܪø
¥t¥~¡ASUMIFS¡BCOUNTIFSµ¥¤½¦¡¬O¤£¬O¤£¯à¨Ï¥Î°ÊºA½d³ò°Ú
§Úªº¦WºÙºÞ²zû©w¸q¤F«Ü¦h¦WºÙ³£¬O¥Î°ÊºA½d³ò(OFFSET)¤U¥h©w¸q½d³ò
¦ý¬O¨C¦¸SUMIFS¡BCOUNTIFSµ¥¤½¦¡³£¨S¦³¿ìªkºâ¥X§t¦³°ÊºA½d³òªº¼Æ¾Ú
¬O¦]¬°OFFSET¬O¥¢©Ê¨ç¼Æ¶Ü¡H¦³¿ìªk¥Î©ö¥¢©Ê¨ç¼Æ°µ¥X°ÊºA½d³ò¶Ü¡H
Q.rar (211.71 KB)
|
|