| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total number of months. | Excel Worksheet Functions | |||
| Can I total only a % of a number (cell) base on total of all cel | Excel Discussion (Misc queries) | |||
| How do I find the total number of the same number/letter in a row | Excel Discussion (Misc queries) | |||
| a number as a percentage out of a total | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
