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

[µo°Ý] SUMPRODUCT ­pºâ¿ù»~ ???

[µo°Ý] SUMPRODUCT ­pºâ¿ù»~ ???

½Ð¬Ýªþ¥ó Book2.rar (9.85 KB)

¦^´_  t8899

13:00¥H«áªº¼Æ¶q¥²¶·¤Ö¤@­Ó±ø¥ó§PÂ_
N15¤½¦¡
=SUMPRODUCT((INDIRECT("B"&$P$1&":B"&$Q$1 ...
Hsieh µoªí©ó 2014-4-21 09:53

­ì¨Ó¤j©ó13:30 ÁÙ¦³5µ§

TOP

¦^´_ 1# t8899

13:00¥H«áªº¼Æ¶q¥²¶·¤Ö¤@­Ó±ø¥ó§PÂ_
N15¤½¦¡
=SUMPRODUCT((INDIRECT("B"&$P$1&":B"&$Q$1)>=--"13:00:01")*(INDIRECT("Q"&$P$1&":Q"&$Q$1)="")*1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD