Hi Dave,

Thank you for your reply.

The problem is that one of the columbs contains letters, not numbers
and sumproduct formula returns #VALUE!

Probably I have to be more specific. I'll give you an example. So,
there are three columbs in my spreadsheet. The first contains time in
which a process starts /for ex. 11:24:32/. The second columb contains
the duration of the process /for ex. 00:03:45/. The third columb
contains the kind of process/ for example SB, SS, etc./.

I would like to find out the average time duration of a given process
/lets say SB/ after 15:30:00.


--
kras
------------------------------------------------------------------------
kras's Profile: http://www.excelforum.com/member.php...o&userid=28667
View this thread: http://www.excelforum.com/showthread...hreadid=483373