try the sumproduct() function
= sumproduct(--(T1:T1000="Davis"),--(timevalue(AR1:AR1000)<=timevalue(00:30)))
the --( changes the logical true false to a 1,0 numeric
the arrays in each section must be the same size and can not be the
shorthand for entire columns
"Denise" wrote:
I have a spread sheet that I need to count if -
If Column T is equal to a certain name (Davis) then I want to count the
times that are in Column AR that are less than or equal to 00:30.
Column T has numerous last names, so I need to specify who I want the times
on.
Thanks for any help.
|