What's Wrong With This?

[Unsigned]

I'm trying to apply the following formula to cell h8:
=sumif(c8:d8, >0, f7 + c8 - d8)
My aim is if cells c8 & d8 = 0 they remaine blank. If a value is entered in
either c8 or d8, the sum of f7 + c8 - d8 will show in h8. I imagine it would
look something like the balance column in a petty cash journal, or something
similar.

 

[J.E. McGimpsey]

One way:

F8 =IF(AND(C8=0,D8=0),"",F7+C8-D8)

 

[Unsigned]

ty

One way:

F8 =IF(AND(C8=0,D8=0),"",F7+C8-D8)