| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula with 2 conditions
I have a spreadsheet with 20000 rows capturing numbers from .01 to $1,000,000
in column D. What I want to do is break these rows into ranges. For example the first range would be .01-1.00, then the next range 501 to 20,000 Then the next range 20,001 to 100,000. I've tried the Sum and Sumif funtion but cannot get them to work. Would this be considered an Array function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a formula to sum with conditions | Excel Worksheet Functions | |||
| two conditions formula | Excel Discussion (Misc queries) | |||
| IF formula for 3 possible conditions | Excel Discussion (Misc queries) | |||
| Formula With Several Conditions | Excel Worksheet Functions | |||
| Help for a formula using two conditions | Excel Worksheet Functions | |||
Threaded Mode
