Crystal Reports Suppress blanks in a formula or skip logic

Message

   I have a list of values with associated currency amounts:

The Arts         $5,000
Theatre         $1,500
Computers    $10,000
Business       $2,000
etc...

I need to only list certain values, but I still need to be able to use their currency amounts on my report to add to the listed amounts:

The Arts = The Arts + Theatre currencies (total of $6,500)

When I use record selection to leave out "Theatre", I can no longer add its currency to "The Arts". If I leave it in, I cannot seem to skip over it in the Details section.

I tried inserting the values into a text object and selected "Suppress blank imbedded values", but that doesn't seem to work. I have a formula like the above one to add the currencies together, but then I need to leave the Theatre line out of my report.

Is there anyway to manage this in Crystal? Can I use some sort of skip logic (If{value}="Theatre" then skip)?

Thanks for your help. I hope this wasn't too confusing.