I'm using the following:

=SUM(IF($B$11:$B$54=B58,$B$11:$B$54,0))

The problem is, that I am forced to only put a number into the cells. Why
can't I put a number, then a word, then use the "left" function to get rid of
the text and use the number in the sum?