This formula:

=sumproduct(--(a1:a10="something"),--(b1:b10="another"),c1:c10)

expects to find numbers in C1:C10. If you have text/errors in that range, then
you'll have trouble.

(You'd have to adjust the ranges to match your data.)

But from what you wrote in your followup, you're only looking at one criteria.

So maybe something like:
=SUMIF(C1:C10,"SB",B1:B10)/COUNTIF(C1:C10,"SB")

Oopsie....

You wanted it after 15:30:00, so back to =sumproduct()

=sumproduct(--(a1:a10=time(15,30,0)),--(c1:c10="sb"),b1:b10)
/ sumproduct(--(a1:a10=time(15,30,0)),--(c1:c10="sb"))

All one cell.

That assumes that the times in column A are really times--they don't include
dates.

(Sum up all the duration times in column B that matches the criteria and divide
it by the count that match both criteria.)



kras wrote:

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

--

Dave Peterson