Filter data
 

I have the following table:
Columns:
A B C D
Date From Date To
A2 B2

Date Unit Category Time
12/9/07 Wilts U/S 2:00
12/9/07 Wilts S 8:00
13/9/07 YAA S 9:00
15/9/07 YAA U/S 3:00
and so on.......

How can I filter the data so that when i enter two dates in cell A2 and B2,
it gives me the totals time under each unit and category between those dates

--
Geo

Filter data
 

In C2 enter:
=SUMPRODUCT(--(A8:A11=$A$2),--(A8:A11<=$B$2),D8:D11)*24

where your Table (including the header is A7:D11)

Jim May


"Geo" wrote:

I have the following table:
Columns:
A B C D
Date From Date To
A2 B2

Date Unit Category Time
12/9/07 Wilts U/S 2:00
12/9/07 Wilts S 8:00
13/9/07 YAA S 9:00
15/9/07 YAA U/S 3:00
and so on.......

How can I filter the data so that when i enter two dates in cell A2 and B2,
it gives me the totals time under each unit and category between those dates

--
Geo