I can't get this formula to work, please help.

=IF(COUNTIF(B128,"<Z*"),0,SUM(SUMIF((F128,F270),F1 280,(F2,F270)),(SUMIF((G128,G270),G1280)),(SUMIF ((H128,H270),H1280))))

The logic is this:

If B128 is not a number result = 0
Else Sum the following three together
If F2 is 0 Sum F2,$F$128, 0
If G2 is 0 Sum G2,$G$128, 0
If H2 is 0 Sum H2,$H$128, 0