I have side-by-side columns; Col. A containing dollar amounts, Col. B
containing numeric exception reasons as below:

Col A Col B
$125 1
$250 2
$75 1,3
$500 4
$200 1,2

The following formula works perfectly fine if I'm only interested in the
number of occurrences of Reason 1 in Col. B (3 occurrences above).

=SUM(LEN($B$10:$B$4000)-LEN(SUBSTITUTE($B$10:$B$4000,1,"")))

Now I need the total dollar amount in Col. A if Col. B equals 1 OR contains
1. In the example above, that answer would be $400 (or $125 + $75 + $200).

How would you alter the formula to return the dollar amount(s)?
Any help at all would be appreciated. Thanx in advance.