SUM of different currencies in single column, SUM of filtered data with criteria.

Rahul Adapala

New Member
Joined
Aug 25, 2018
Messages
1
Hi every one,

I'm preparing a database for my company's sales data. we deal in different currencies, but I want all the accounting values of one category in single column. This led to having different currencies in single column. Also I have categorized data into fiscal quarters with a formula. Now I have got two questions.
1. How to get the sum of different currencies($, £, ₹) which are in a single column.
2. How to filter the data based on fiscal quarters and then extract the sum of the order values in that quarter. Again these order values are in different currencies($, £, ₹) in single column. The solution should be dynamic.

Thank you
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

yky

Well-known Member
Joined
Jun 7, 2011
Messages
1,812
Office Version
  1. 2010
Platform
  1. Windows
If you put different currency in different column, you'd not need to ask these questions, would you? Having said that, I see two solutions for you. First, you put different currency in different column and hide the columns. In another column, you use formula like "=k1", "=l2", "=m3", etc. to "copy" the currencies to a single column. Then, you can sum different currency easily by summing the data in the hidden column. Second, you can use SUMIF to sum different currency if there is a way to tell what currency is in what cells. For example, if column C contains the currency code (USD, INR, GBP) and the amount is in column E, you can do "=SUMIF(C2:C30, "=USD", E2:E30). For quarterly data, you can use SUMIFS so you can have date and currency as the criteria.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,617
Messages
5,597,196
Members
414,131
Latest member
Balakrishnan2027

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top