Please help with last formula for order form.

[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 SU
of 3 different columns that are separated. I am not able auto fil
strait down the column, because the information is separated in group
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

+-------------------------------------------------------------------
|Filename: excel problem.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=308
+-------------------------------------------------------------------

 

[juleoni]

Hi,

I can show you how to write the formulas for this but would be fa
easier if you send me a copy of your workbook.

If you still need the help, feel free to email me the document.

Thank you for your reply Spencer101. I found a workaround whic
satisfies me. I just unmerged the cells with titles then remerged the
except for that one cell. I centered back the titles by eyeing where i
was last

+-------------------------------------------------------------------
+-------------------------------------------------------------------