- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2015-11-10 14:21 ½s¿è
¦^´_ 4# a88176
¥H1#¹Ï¨Ò(µLÄæ¦ì¦WºÙ)¶i¦æ°ÊºA½d³ò©w¸q
1.©w¸q¦WºÙ¡uy¡v¡A°Ñ·Ó¨ìÄæ¦ì¿é¤J =OFFSET(¤u§@ªí1!$B$1,,,COUNTA(¤u§@ªí1!$B:$B))
©w¸q¦WºÙ¡ux¡v¡A°Ñ·Ó¨ìÄæ¦ì¿é¤J =OFFSET(¤u§@ªí1!$A$1,,,COUNTA(¤u§@ªí1!$B:$B))
2.¡uAÄ欰"ªÅ¥Õ"¥BBÄæȬ°"¥Ò"¤§µ§¼Æ¡vªºpºâ¦¡¿é¤J
=SUMPRODUCT((x="")*(y="¥Ò"))
½Ð°Ñ¦Ò¡I |
|