Not sure why you are getting an error in that formula. That error usually
happens when you are using an incorrect Argument or Operator in a formula.
Are you trying to add or multiply?

You dont' really need the SUM Function the way you have your formula written.
Why not use =B13*H13?

If the Error persists, you could try:
If(Iserror(B13*H13),"",B13*H13)
This won't fix the error, but it will mask it when it occurs.

tj

"Joe Shell" wrote:

i am designing a cost spreadsheet for recipes, i need to exclude cells from a
formula when, no data is entered, then i need to include the cell when data
is entered.
Input (b13) Input2 (h13) Result
0 0 #Value!
When i enter =sum(b13*h13) i get #Value!

If anyone understands my problem, PLEASE HELP