I'm working on a form for payroll, basically I have a layout of Sunday - Saturday along with Vacation column, AI day column and Holiday with the option of how many hours the employee worked that day, a V for a vacation day, an A for an Attendance Incentive day or a H for a Holiday. I know how to convert the letters into numbers and add them together but what I can't seem to get to work is returning a blank cell if there is no number or if the total = 0. 
=IF(B2="","0",(IF(B2="V",CODE(B2)-78)))+IF(C2="","0",(IF(C2="V",CODE(C2)-78)))
The above code works fine but it always leave a "0" in the cell if there are no V's during the particular week. If I remove the "0" and leave it as "" the code no longer works. 
B2="","0"  vs  B2="",""
I have tried variations of using SUM but no luck. I greatly appreciate any help or tips on a working version of this formula.