mauirlesette
New Member
- Joined
- Jan 14, 2016
- Messages
- 3
My control value is D46. My data is A7 to A141 for the min number and B7 to B141 for max, and C7 to c141 for the amount. I used the following formula and it works perfectly. I need to include all the data down to row 141. Is there an easy way to include all the values from rows 7-141? (other than typing each statement manually?)
=IF(AND(D46>Sheet3!A7,Jan!D46<=Sheet3!B7),Sheet3!C7)+IF(AND(D46>Sheet3!A8,Jan!D46<=Sheet3!B8),Sheet3!C8)
<tbody>
</tbody>
=IF(AND(D46>Sheet3!A7,Jan!D46<=Sheet3!B7),Sheet3!C7)+IF(AND(D46>Sheet3!A8,Jan!D46<=Sheet3!B8),Sheet3!C8)
at least | but less than | equals |
0 | 115 | 0 |
115 | 120 | 2 |
120 | 125 | 3 |
<tbody>
</tbody>