How do I merge these two formulas?

In one set of row data, I use the following formula in cell (CE64)

Formula:

Please Login or Register  to view this content.

This returns "-" if cells are blank.

In a second set of row data, I use the following formula in cell (AO64)

Formula:

Please Login or Register  to view this content.

this also returns "-" to suppress the #Value error.

The problem is that, obvious it does not total the first set of data (AF64:AM67) unless there is a value in (CE64)

how do I get around this? I thought about replacing the formula in (AO64) with a combination of the following formulas, I just cant figure it out.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Please help......I hate the "0" value in blank cells!

Thanks prontonLeah! I guess I was trying to make things more complicated than they had to be.......