ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

«D©T©w¦C¼Æ­pºâ¡I

¦PE¤j¡G
¢Ñ¢²¤½¦¡
=IF(A3="","",B3+SUMPRODUCT((LOOKUP(ROW(A3:A$16),ROW(A3:A$16)/(A3:A$16<>""),A3:A$16)=A3)*(F3:F$16={"¤½®t","½Ð°²"})*{1,-1}))
©Î:
=IF(A3="","",B3+SUMPRODUCT((SUBTOTAL(4,OFFSET(A$2,1,,ROW(A3:A$16)-2))=A3)*(F3:F$16={"¤½®t","½Ð°²"})*{1,-1}))

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD