ExcelBanter - Please help with last formula for order form.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Please help with last formula for order form. (https://www.excelbanter.com/new-users-excel/445447-please-help-last-formula-order-form.html)

Please help with last formula for order form.

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!

Quote:

Originally Posted by juleoni (Post 1599695)

Hi,

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

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

Quote:

Originally Posted by Spencer101 (Post 1599889)

Hi,

I can show you how to write the formulas for this but would be far 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 which satisfies me. I just unmerged the cells with titles then remerged them except for that one cell. I centered back the titles by eyeing where it was last.