Adding Separate Columns of a Table To Obtain 7% of Total

[oldeirish]

How to calculate 7% of tax from 3 different columns? Can I input all my data then convert to a table?

[TABLE="width: 380"]
<tbody>[TR]
[TD="width: 172"]

New Subtotal​

[/TD]
[TD="width: 120"]

Credit​

[/TD]
[TD="width: 148"]

Over Due Fee​

[/TD]
[TD="width: 148"]

Column1​

[/TD]
[TD="width: 172"]

HST 7%​

[/TD]
[/TR]
[TR]
[TD="width: 172"] $ 365.00
[/TD]
[TD="width: 120"] $ 5.00
[/TD]
[TD="width: 148"] $ 10.00
[/TD]
[TD="width: 148"][/TD]
[TD="width: 172"]

37070%​

[/TD]
[/TR]
[TR]
[TD="width: 172"] $ 500.00
[/TD]
[TD="width: 120"] $ 70.00
[/TD]
[TD="width: 148"] $ 5.00
[/TD]
[TD="width: 148"][/TD]
[TD="width: 172"]

57035%​

[/TD]
[/TR]
</tbody>[/TABLE]


This is the first I tried
=SUM([@[New Subtotal]]+[@Credit]+[@[Over Due Fee]]*7%)

This is the 2^nd one I tried
=SUMPRODUCT([@[New Subtotal]]+[@Credit]+[@[Over Due Fee]]*0.07)

Thank you so very much!! J

 

[konew1]

=SUM([@[New Subtotal]],[@Credit],[@[Over Due Fee]])*7%

 

[oldeirish]

Thank you so much for your time, that worked!!!

 

[oldeirish]

I spoke too soon, I apologize. The formula is great, but the percentage always comes out in the thousands.

Thank you again for all your help!

 

[konew1]

That surprises me, but you could use =SUM([@[New Subtotal]],[@Credit],[@[Over Due Fee]])*0.07 .
Did I misunderstand? is the answer wrong, or is the formatting on the formula cell wrong, or is the original data in thousands and you want the new column to show the unrounded amount?

 

[Peter_SSs]

I think it is just the formatting of that column the formula is in. Select the column and format it as Number, with 2 decimal places (or Currency if you want).

Excel Workbook
	A	B	C	D	E
1	New Subtotal	Credit	Over Due Fee	Column1	HST 7%
2	$365.00	$5.00	$10.00		,,])*7%]26.60
3	$500.00	$70.00	$5.00		40.25
Calc %

 

[oldeirish]

Hi,

Yes, II figured out what is I did wrong. Apparently, I’m not that bright! Lol

I had the column set up for % of those combined numbers (in percentage), not 7% of the total that would give the 7% dollar amount to be added in the GST + HST Total Line.

I have to admit I want to articulate what I need the end result to be, but have a hard time conveying that. My apologies for this blunder.

On another note, I have a completely different set of questions to do with Table and Pivot Table information. It is in another post. Does anyone have any ideas of how I can accomplish these formulas and get the outcome I need? Here is beginning of original post.

http://www.mrexcel.com/forum/excel-questions/820378-help-pivot-table-data-calculation.html

Thank you so much, and my apologies for the murkiness in the question.