View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Geo Geo is offline
external usenet poster
 
Posts: 66
Default Total under certain number?

Hi,
I have a spreadsheet with data from two different units. What I would like
to do is to be able to total, for each unit, figures under a certain number
and totals for above the same number.
Example:

Unit Hours
A 2
A 2
B 3
A 4
B 1
B 1
and so on.....

Totals for: Unit Hours
Under 5 hours A 4
B 4

Over 5 hours A 4
B 1


Hope that helps!
--
Geo