Hello,
I am working on a formula that will count how many drill taps are needed on a worksheet, and return an estimated time value. Column B is qty of pieces. Column F is the type of taps. I am figuring 2 mins per tap, so row 1 would be 4 minutes, and row 2 would be 12 minutes. total below would be 16 minutes.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I thought sumifs would work, but its not accounting for the second possible tap in column c.
=SUMIFS(A:A,C:C,"*m*")
results in 5 (2*1 + 3*1)
when it should be 2*(2*1) + 3(2*2) = 16
I am working on a formula that will count how many drill taps are needed on a worksheet, and return an estimated time value. Column B is qty of pieces. Column F is the type of taps. I am figuring 2 mins per tap, so row 1 would be 4 minutes, and row 2 would be 12 minutes. total below would be 16 minutes.
QTY. | Description | Tap |
2 | poplar | m12/- |
3 | oak | m12/m12 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I thought sumifs would work, but its not accounting for the second possible tap in column c.
=SUMIFS(A:A,C:C,"*m*")
results in 5 (2*1 + 3*1)
when it should be 2*(2*1) + 3(2*2) = 16