Do you mean you want a sum of all the cells of Unit 1 with a value of 0:20
or less and another of cells with a value greater than 0:20?

If so then use:

Unit 1 value 0:20 (in C1) or less:

=SUMPRODUCT((A2:A6=1)*(B2:B6<=C1)*B2:B6)

Unit 1 value over 0:20:

=SUMPRODUCT((A2:A6=1)*(B2:B6C1)*B2:B6)

Unit 2 value 0:20 or less:

=SUMPRODUCT((A2:A6=2)*(B2:B6<=C1)*B2:B6)

Unit 2 value over 0:20:

=SUMPRODUCT((A2:A6=2)*(B2:B6C1)*B2:B6)

I assumed that values of exactly 0:20 are counted with the less than 0:20

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Hoyos" wrote in message
...
Here is a sample:
A1= 0:20 (Time)

A B
Unit Time
1 0:25
2 0:10
1 0:10
1 0:20
2 0:10
Total 1:15

In cell G1 Unit1 Total under cell A1
G2 Above cell A1

In cell H1 Unit2 Total under cell A1
H2 Above cell A1

Is it possible for the figures under cell A1. When reaching that figure it
freezes.

--
Hoyos


"T. Valko" wrote:

Totals from where? I think you need to provide more DETAILS and a sample
with the expected results.

--
Biff
Microsoft Excel MVP


"Hoyos" wrote in message
...
I have a spreadsheet that adds hours of two different units (unit1 and
unit2). Under each unit heading I have two cells keeping a total for
that
unit. What I would like to do is for Cell1, of each unit, show total
figure
up to and including a figure in cell A1 then totals above the figure in
A1
to
continue to be summed in cell2.
--
Hoyos