S Himmelrich,

What about wrapping an IF() function around your formula?

Enter this formula in K1
=IF(J1="","",SUM(J1/MACRO!$G$11))

HTH,

Conan Kelly






"S Himmelrich" wrote in message
...
the formula is basically:

=SUM(J1/MACRO!G11)

J1, must change as formula moves down each row, "MACRO!G11" stays the
same