- ©«¤l
- 617
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 662
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-3-7
|
¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-16 08:56 ½s¿è
¦^´_ 3# t8899
1¡B½Ð©óBook3.xls¥ý¶i¦æ¡u©w¸q¦WºÙ¡v (±ø¥ó¡Gpºâ¸ê®Æ¸s³Ì«á¤@µ§¦³¸ê®ÆªºÀx¦s®æ©¹«e¼Æ30ÓÀx¦s®æ)
x =Sheet1!$H$3:$H$301
y =OFFSET(Sheet1!$D$1,MAX(IF(x="v",ROW(x),FALSE))-30,4,30)
z =OFFSET(Sheet1!$D$1,MAX(IF(x="v",ROW(x),FALSE))-30,2,30)
2¡B±N1#°Ýªº¤½¦¡=SUMIF(H3:H301,"v",F3:F301)§ï³y¦¨
=SUMIF(y,"v",z)
½Ð°Ñ¦Ò¡I |
|