I'd probably do it all in the SQL statement, using COALESCE or simple addition depending on whether the on whether the empty fields use NULL or zero.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.