How to sum multiple cells in a referenced sheet without typing said sheet name again

Can someone please tell me how to write a SUM formula that sums multiple cells in a referenced sheet, without retyping the referenced sheet name again and again.
I like my formulas clean and short so I don't want this big bulky thing with 4 reference names in there when I only need 2.

The formula I'm having to use now:
=IF(SUM('DISTRIBUTION WORK SHEET'!D4:E4,'DISTRIBUTION WORK SHEET'!D30:E30)<=0,"",SUM('DISTRIBUTION WORK SHEET'!D4:E4,'DISTRIBUTION WORK SHEET'!D30:E30))

The formula the way I think it should look, but Excel disagrees:
=IF(SUM('DISTRIBUTION WORK SHEET'!(D4:E4,D30:E30))<=0,"",SUM('DISTRIBUTION WORK SHEET'!(D4:E4,D30:E30)))

Originally Posted by TMS

Maybe

Formula:

Please Login or Register  to view this content.

and use a Custom Format to hide the zero values.

Hey thanks!
For what I was doing I didn't need the MAX function. The thing I hadn't thought of was the conditional formatting. I never really learned how to use it so I just don't touch it, but I was able to figure it out for this scenario.