You can't reference a sum  the way you're trying to, but there are a few
ways you could do this.

The easiest, I suppose, would be to put  a formula in a new cell to sum
the others and simply reference the value of this in you code. But if
you can't or don'twant to do that, then this is probably the simplest
way of doing the sum inside your code:

If Range("B6").Value + Range("B7").Value + Range("B10").Value +
Range("B14").Value => 3 then