Adding an Expression to a Range in the Excel COUNTIF Function -

simple question end in me using different function, not entirely sure same command expression added comparison.

here simple function:

=countif('service calls'!e:e,c3) 

this return if exact match found, querying time column holds hours , minutes. want pull whole hour can collect service calls per hour. how go running countif function added modifier such hour() each cell in comparison? right in code quickly, reason brain goes blank when comes excel.

i have tried this, never work:

=countif(hour('service calls'!e:e),c3) 

any thoughts or direction great! guys , gals!

try,

=sumproduct(--(hour('service calls'!e:e)=c3), sign(len('service calls'!e:e))) 

the sumproduct function not thrown errors if of data cannot have hour stripped out of it, additional error control have added.

sumproduct calculate every cell tell to. not not truncate full column references extents of data countifs function. wary using full column references sumproduct; pare down cell ranges reasonable approximation of actual scope of data.

if data strictly 'holds hours , minutes' may more appropriate (and more efficient).

=countifs('service calls'!e:e, ">="&time(c3, 0, 0), 'service calls'!e:e, "<"&time(c3+1, 0, 0)) 

this countifs solution not appropriate datetime values sumproduct peel out hour of values containing both date , time.