=IF(G21="",0,A21*G21)

Regards

Trevor


"Jaladino" wrote in message
...
when summing up in H21-- A21*G21 and there is no entry for G that row I'm
getting a #Value! error, can I change somethink so its blank rather than
Value (which will interefere with the total)