Help with Excel Code to pull different city tax rates and add up the sales tak rendered

I want to find out how to sort tax rates, with the corresponding tax Id rate changes

Example:
Column E4 (Gross) Column F4 (taxed) Column M (Corresponding Tax Id) Column N4 (Tax Rate)
$84.32 $7.32 3120 .095
$190.05 $15.05 3100 .086
$170.82 $14.82 1724 .095

I need a formula or table that will sort the different tax id's listed into there own columns with column F(taxed amount) total at bottom.

Like for example

I would like it to have the Tax Id's listed separately, than the taxed amounts, and gross
Sorted Columns: Tax ID Taxed amount gross
(all lines that have "3120" rate) =E4-(E4/(1+N4)) E4

and so on, so it would pull all the Tax id's labeled 3120 and sort them, and add them, and than another line with tax id's labeled 3100 and so on.

Let me know if this sounds confusing and I will try to reword it, any help would be much appreciated. Thank you

Hi

Also, can you add an example file that shows both the raw data (as per the post above), and exactly how the output is to be formatted.

rylo

Thanks Rylo,

Here is an example sheet of how it is now, did you want me to add one that shows how I would like it to look?

Hi

Yes please, and also add some dummy data for the relevant items, and how the result should look for that dummy data.

rylo

If you notice in the attached file, Column M, as the tax rate code. Each customer has a different code, depending on the City the work is rendered in. I would like a formula that would pull multiple lines by there tax code and give me the total of the tax for each rate, as well as the gross minus tax total.

Hi

Is there supposed to be an attachment in #5?

rylo