Here's another way, provided your format is consistent...

=SUMPRODUCT(--(A2:A13=F2),--(B2:B13=G2),SUBTOTAL(5,OFFSET(D2:D13,ROW(D2:D
13)-ROW(D2),0,3)))

....where F2 contains the year, such as 2003, and G2 contains the
quarter, such as Q2. Also, if you're going to change the way your data
is laid out, as Biff has described, you can easily do that by doing the
following...

1) Select A2:B13

2) Edit Go To Special Blanks Ok

3) Press =

4) Press the 'Up Arrow'

5) Confirm with CONTROL+ENTER

Hope this helps!

In article ,
"Mark Rugers" wrote:

Hello,

I want to find the minimum time in which a batch has been produced for each
quarter of a year. I have tried different formulas (included arrays +
Control/Shift/Enter) with unsatisfied results. Below is a simplified example
for the year 2003.

A B C D
1 Year Quarter Date Duration of batch
2 2003 Q1 01-02-03 13:45
3 02-02-03 12:45
4 10-03-03 9:54
5 2003 Q2 11-04-03 11:24
6 24-05-03 11:00
7 24-06-03 10:15
8 2003 Q3 14-07-03 11:15
9 14-07-03 10:45
10 02-08-03 16:30
11 2003 Q4 02-11-03 15:00
12 22-11-03 12:45
13 23-12-03 13:00

I hope this makes sense.

Kind regards

Mark