How to filter column and do sumn

[bhanu.priya2 (Bhanu Priya)]

Hi Team,

Code	A	B	Currency
1	700000	150000	MYR
2	5000	150000	USD
3	100	200000	AUD
4	10000	10000	USD
5	10000	100000	GBP
6	63332	104721.54	SGD
7	184491.1	20000	GBP
8	27536	90000	AUD
9	50	90000	MYR

Here i need to Total A and B by “Code” by each currency, please help me to achive this

also i need to paste currency wise in different sheet

[rlgandu (Rajyalakshmi Gandu)]

@bhanu.priya2

can you please share the sample output file

[lrtetala (Lakshman Reddy)]

Hi @bhanu.priya2

Can you try the below

Sequence13.xaml (9.7 KB)

Output:

Data1.xlsx (12.2 KB)

Regards,

[bhanu.priya2 (Bhanu Priya)]

Hi This is working fine, but i need sum of A and B in each location sheet

[bhanu.priya2 (Bhanu Priya)]

Sample.xlsx (157.0 KB)
here is the sample file

[lrtetala (Lakshman Reddy)]

@bhanu.priya2

Sequence13.xaml (13.6 KB)

Output:

Sample.xlsx (355.1 KB)

Regards,

[bhanu.priya2 (Bhanu Priya)]

This is running frm long time and nothing is happening

[lrtetala (Lakshman Reddy)]

@bhanu.priya2

Data is around 5k rows that’s why it is taking more time, in my machine it takes around 2 min 30 sec

Regards,

[bhanu.priya2 (Bhanu Priya)]

Sample.xlsx (368.2 KB)

attached new sample file

sorry it is giving me sheets with Asset code, i need sheet name with currency, this has to do sum according to currency

[lrtetala (Lakshman Reddy)]

@bhanu.priya2

How about the following?

Sequence13.xaml (14.7 KB)

Output:

Sample (2).xlsx (422.0 KB)

Regards,

[bhanu.priya2 (Bhanu Priya)]

Hi , M sorry not to sum adding extra total column, in the DR column itself i have to sum the entire DR and CR column not together

[lrtetala (Lakshman Reddy)]

@bhanu.priya2

Sequence13.xaml (14.7 KB)

Output:

Sample (2).xlsx (269.1 KB)

Regards,

[bhanu.priya2 (Bhanu Priya)]

Thank you so much it is working fine