As shown in figure, all need statistics C column the date 11-12 points, E column machine, the number of 13 and 17, please answer, thank you

CodePudding user response:

Excel home duyanzhang already answer

=SUMPRODUCT (- (HOUR (C4: C35)=11), (E4: E35=13) + (E4: E35=17))
Array formula

Excuse me, if not for integer within 11 points, such as how to modify the data between 11.30 to 11.40?

CodePudding user response:

=SUMPRODUCT ((MOD (C4: C35, 1) & gt;="11:30" * 1) * (MOD (C4: C35, 1) & lt;" At "* 1) * ((E4: E35=13) + (E4: E35=17))) 

CodePudding user response:

The building Lord wait to solve the problem???????