| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula figures less than & greater than?
I need a formula that adds all hours 6 and under (for example: If the hours
are 5, 6, 7, 5, 8 then I want the sum to be 28 (5+6+6+5+6)). I also need a formula that will then add all hours over 6 (for example: If the hours are 8, 7, 6, 9, 6, 8 then I want the sum to be 8 (2+1+0+3+0+2)). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find greater of two values??? | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Formula for number of entries in colum that are greater than 2 hr | New Users to Excel | |||
| trying to make a formula for percent if greater than a value | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
