Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF function in "Price quote with tax calculation" templae
able?Hi:
I am trying to modify the "Price quote with tqx calculation" template. We have 2 sales taxes. The first tax is calculated as a % of the total sales+Tax 1. I need to show each tax separately, then total them. The Quote template has a column "Taxable?" (Column E) The tax is calculated only on the items with a T in Column E. Cell F31 is Subtotal: =SUM(F22:F30) Cell F32 is Tax Calculation 1: =7%*SUMIF(E22:E30,"T",F22;F30) Now I need to calculate Tax 2, which is 7.5% of the (Subtotal + Tax1). i.e. I need to add the Subtotal and Tax 1, multiply it by 7.5% and show that result. But, like Tax 1, only for the items with a T in Column E. I am trying the formula: =7.5%*SUMIF(E22:E30,"T",F31:F32) but without success: Any suggestions would be much appreciated. Thank you. -- Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
Improve SUMIF function to sum more than one column | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |