This is a different question than the previous but I typed the following in cell C21 and it says "#VALUE!"
=IF(E3:E17="Pioneer 33r87",B21-D3:D17)
What I would like to do is if the text "pioneer 33r87" is found in cells E3 through E17 then take the number entered in the cell that is to the left of it i.e. D3 and subtract that amount from cell B21. What would the correct formula look like. Thanks.
=IF(E3:E17="Pioneer 33r87",B21-D3:D17)
What I would like to do is if the text "pioneer 33r87" is found in cells E3 through E17 then take the number entered in the cell that is to the left of it i.e. D3 and subtract that amount from cell B21. What would the correct formula look like. Thanks.