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

¦h±ø¥ó­pºâ­È (§t¤é´Á½d³ò¤º©Ò¥ðªº®É¼Æ­È)

=SUMPRODUCT((¤u§@ªí3!$B$2:$B$300=$B2)*(¤u§@ªí3!$C$2:$C$300>=$R2)*(¤u§@ªí3!$C$2:$C$300<=$S2)*(¤u§@ªí3!$E$2:$E$300=D$1),¤u§@ªí3!$H$2:$H$300)

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD