I have figured out how to set conditions to add amounts based on complete
cell values.

What I want to know is if I can set a condition that will add a specified
cell if another cell contains a certain value.

For example. I have a cell with numbers and text which reads something like
075555 AAAAAAAAA... and another cell in that column which reads 375555
BBBBBBB. What I want is for the formula to pick up the first two numbers
only. So 07 and 37 (as I could have multiple descriptions in that column but
the descriptions will always start with either 07 and 37).

I want the sum of the descriptions starting with 07 and the sum of the
descriptions starting with 37. Is there a way to do this?