| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Negative Thresholds in SumProduct
I'm using a SumProduct formula to determine a differential rate for a
threshold amount, but my table includes negative numbers, which throws off the formula. Here is the table and formula I am using: Column I/J/K Threshold/Contribution/Diff Rate <-3409 -750 -750 -3409 22% 22% 12400 25% 3% 15600 29% 4% 18700 34% 5% 21900 40% 6% 25000 47% 7% =SUMPRODUCT(--(H14$I$4:$I$9), (H14-$I$4:$I$9), $K$4:$K$9) Any suggestions appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
