Argh.

You mean if there are no entries you want the cell with the formula to be blank

Try

=IF(SUMPRODUCT(MAX(--(A2:A9="TEST")*(--(B2:B9))))=0,"",SUMPRODUCT(MAX(--(A2:A9="TEST")*(--(B2:B9)))))

Or

use the formula originally provided and goto > tools > options > View and untick Zero values

VBA Noob