SUMIF formula getting error

[nespa]

Hello,

I am trying to get the pecentage in Cell F with G formula below, but
want to get the sum only if B5 is not Zero.

I am trying to get the the sum if B5 is not 0 usin
SUMIF(((B5-(C4+D4))/B5*100),">0"), but this is given me an error.
Should I you a different formula?


Cells:
RESULT
B C D D F G
3 0 0 12 error SUMIF(((B5-(C4+D4))/B5*100),">0")

12 100 =((B5-(C4+D4))/B5*100)




Thanks for your help

 

[duane]

=IF(b5>0,(B5-(C4+D4))/B5*100),0