There are several spells which target all creatures within a given area (such as Fireball), regardless of whether they are friendly to you or not. Sculpt Spell allows you to modify the area of such a spell so that certain creatures within are protected against the spell's effects. The most common usage for this would be to throw a Fireball into the middle of a combat without also damaging your melee teammates.
Hope that helps! Let me know if you need more clarification :)