¥[¯Z¶O¦p¦ó­pºâ¡H

q1a2z5

¥Ñ©ó¨C¦ì­û¤u¥[¯Z¶O§¡¤£¤@¡A¦¹¥[¯Z¶O­n¦p¦ó³]¤½¦¡©O¡H

ÁÂÁ¡I

Hsieh

¦^´_ 1# q1a2z5
C2=INT(SUMPRODUCT(FREQUENCY(ROW(INDIRECT("A1:A"&B2)),{8,10}),{183.16;243.61;304.05}))

q1a2z5

ÁÂÁ§Aªº¸Ñµª,
¥i§_±N·í¤é¥[¯Z®É¼Æ¤Îª÷ÃB§@¢²ºØ°Ï¤À¡H
ÁÂÁ¡I

Hsieh

¦^´_ 3# q1a2z5
«e8¤p®É¤p®É¼Æ
D2=INDEX(FREQUENCY(ROW(INDIRECT("A1:A"&$C2)),{8,10}),1)
9~10¤p®É¤p®É¼Æ
F2=INDEX(FREQUENCY(ROW(INDIRECT("A1:A"&$C2)),{8,10}),2)
11¤p®É¥H«á¤p®É¼Æ
G2=INDEX(FREQUENCY(ROW(INDIRECT("A1:A"&$C2)),{8,10}),3)

Bodhidharma

¦^´_ 4# Hsieh

¬O»¡¦pªG¤À¶}¨Ó³B²zªº¸Ü¡A¨ä¹ê¥Î²³æªºif§PÂ_§Y¥i
D2=IF(C2>8,8,C2)  «e8¤p®É
F2=IF(C2>10,2,IF(C2>8,C2-8,0))  9~10¤p®É
G2=IF(C2>10,C2-10,0)  10¤p®É¥H«á

ML089

¦^´_ 3# q1a2z5

D2 =MIN(C2,8)
F2 =C2-D2-G2
G2 =MAX(C2-10,0)

smartally

ÁÂÁ±оǡA¯uªºª¾¹D¤F

hcm19522

http://blog.xuite.net/hcm19522/twblog/404664224
D2:D4=INT(SUM(--TEXT((B2-{0,8,10})*{183.16,60.45,60.44},"0.00;!0")))