How to Each Dealership Name i have to get the total amount in excel sheet

[Shravyaganiga9895 (Shravya)]

[Shravyaganiga9895 (Shravya)]

Under Each Dealership name i have to get the Total amount

[Brandon_Cunningham]

Possible to populate another cell with sumif? Or is this out of scope?

[Shravyaganiga9895 (Shravya)]

I Need the output this way after each dealship name , i have to get the total

[Srini84 (Srinivas)]

@Shravyaganiga9895

Check below post for your reference

How to find and add subtotals of values in the data table

Hi everyone, I keep the table that get from Sql Server as a data table. This data table has ‘expense fields’ and ‘amount’ columns. Is it possible to find the subtotal of each of these expense fields and add them as additional rows to the datatable? For example; if this is my data table; (i am show it for instance in excel file but in the reality it is a data table) [image] i want to find this; (and then i will tranfer it in a excel file) [image] Here is sample data folders ExpenseField…

Hope this may help you

Thanks

[Shravyaganiga9895 (Shravya)]

@Srini84 Thank you for You Kind Help, I will try to work on It