Excel每日一题200，指定时间段的数据，如何求和？

Excel每日一题200，指定时间段的数据，如何求和？ 1. =SUMIF(C3:S3,$C$2:$S$2,">="&E$9,$C$2:$S$2,"<="&E$10) 2. =SUMIF(C3:S3,$C$2:$S$2>=E$9,$C$2:$S$2<=E$10) 3. =SUMIFS(C3:S3,$C$2:$S$2,">="&E$9,$C$2:$S$2,"<="&E$10) 4. =SUMIFS(C3:S3,$C$2:$S$2>=E$9,$C$2:$S$2<=E$10)