Originally Posted by juleoni

I am able to accomplish this with 1 column by the formulas below.

Cell H160 is the subtotal: =IF(SUM(H72:H111)0,SUM(H72:H111),"")
Cell H166 the total: =IF(SUM(H160)0,SUM((H160*H163)+H160),"")
Cell H163 is for Tax.

I am almost finished creating an order form. I would like to get the SUM of 3 different columns that are separated. I am not able auto fill strait down the column, because the information is separated in groups with titles, and the cells are not identically sized.

I tried varations of this formula: =IF(SUM(H72:H111)+(116:131)+(135:154)0,SUM ((H72:H111)+ (116:131)+ (135:154),"")). I am horrible with formulas. Please help!