[ ίΔΜϋΦ | κ(ΕVXV) | SΆυ | ίO ]
@
wAQEN°f[^©ηΤΚvlπvZ·ιxir`snj
`ρΙAQAaρΙN°ΜΒlf[^πόΝB
@iαFAQ22:00AN°6:50j
»κΌκ40lφxΜf[^ͺόΝ³κΔ’ιͺA
@»±©ηAAQπ20:00άΕΙQ½Μͺ½lA21:00άΕΙQ½Μͺ½lA
@Ζ’€ζ€ΙA»κΌκΜΤΡͺ½l’½Μ©πWv΅½’B
COUNTIFπg¦Ξζ’Μš倩H
@Η’ACfAͺ κΞ³¦ΔΊ³’B
excel2007AwindowsXPΕ·B
ζ롨蒡ܷB
=SUMPRODUCT((HOUR(A1:A100)<20)*1) Μζ€Θ`ΕūȒš倩B ι’Ν SUMIFS Εΰ’―ιΖv’ά·B (Mook)
SUMPRODUCTβHOURπgΑ½vZΝAZΚs«ΕΕ«άΉρΕ΅½B
ΕΰAΦΜΰΎπΗρΎΐθΕΝίιϋ@ΕΝΘ’ζ€ΘCͺ΅ά·B
SUMIFSΕΝ20:00ΙQ½lͺ½lΖ’€vZΝΕ«ά΅½B
΅©΅A20:00`20:59ΜΤΙQ½lͺ½l©Ζ’€vZΝΕ«άΉρΕ΅½B
tB^Ι©―ΔALόπ²ΧΔ©ηκΒΈΒASUMIFSΕvZ΅ά΅½B
³¦ΔΈ« θͺΖ€²΄’ά΅½B
ΰ΅AκxΕ20:00`20:59ΜΤΙQ½lͺ½l©Ζ’€vZϋ@ͺ κΞAά½³¦ΔΊ³’B
2007ΘηCOUNTIFSΦΕ =COUNTIFS(A:A,">=20:00",A:A,"<=20:59") η’ΕΗ€Ε΅ε€H ij
π¦ιΎ―ΘηACOUNTIFSΕ΅½ΛB
20:00`20:59 ΙQ½Ζ’€ΜΕ κΞA =SUMPRODUCT((HOUR(A1:A100)=20)*1) ΕΰΕ«ιΖv’ά·B (Mook)
(20:00`20:59ΜΤΙQ½l) = (20:59άΕΙQ½l)@-@(19:59άΕΙQ½l)@ΕvZΕ«ά·B(NB)
[ κ(ΕVXV) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.