Totaling of different currencies in a column separately

[krishco68]

Dear Experts,
I have a range of currencies in a single column, I want to have totals currency wise separately.
the example values are given below. I want the 3 currencies totals separately in another column.

[TABLE="width: 105"]
<colgroup><col></colgroup><tbody>[TR]
[TD] GBP 428.00[/TD]
[/TR]
[TR]
[TD] GBP 264.11[/TD]
[/TR]
[TR]
[TD] GBP 121.22[/TD]
[/TR]
[TR]
[TD] GBP 26.40[/TD]
[/TR]
[TR]
[TD] GBP 10.75[/TD]
[/TR]
[TR]
[TD] GBP 219.53[/TD]
[/TR]
[TR]
[TD] GBP 75.58[/TD]
[/TR]
[TR]
[TD] GBP 10.75[/TD]
[/TR]
[TR]
[TD]₦2,000.00[/TD]
[/TR]
[TR]
[TD]₦1,000.00[/TD]
[/TR]
[TR]
[TD]₦850.00[/TD]
[/TR]
[TR]
[TD]₦550.00[/TD]
[/TR]
[TR]
[TD]₦4,000.00[/TD]
[/TR]
[TR]
[TD]₦4,000.00[/TD]
[/TR]
[TR]
[TD]₹ 7,000.00[/TD]
[/TR]
[TR]
[TD]₹ 2,900.00[/TD]
[/TR]
[TR]
[TD]₹ 600.00[/TD]
[/TR]
[TR]
[TD]₹ 1,000.00[/TD]
[/TR]
[TR]
[TD]₹ 2.88[/TD]
[/TR]
[TR]
[TD]₹ 160.00[/TD]
[/TR]
[TR]
[TD]₹ 150.00[/TD]
[/TR]
[TR]
[TD]₹ 140.00[/TD]
[/TR]
[TR]
[TD]₹ 140.00[/TD]
[/TR]
[TR]
[TD]₹ 1,500.00


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

 

[krishco68]

Sir,
I am Sorry, I abide with the forum rules this will not repeat again.

The answer which I have received not solved the problem. hence I keep replying to the thread.

Regards,
Murali Krishna R

 

[SpillerBD]

Formatting is not data.
Excel can calculate using data very easily. If you wish to calculate using formatting, you typically need to use VBA to extract the formatting as some type of data.
However, if you provide the currency type as a separate field, it all becomes very easy using a Pivot Table for your request.

 

[Fluff]

@krishco68
Did you see the suggestion from mole999 in post#2?

 

[SpillerBD]

Mole's post assumes that the values are text. You don't evaluate on the formatting part of a cell, but the value.

 

[krishco68]

post 2 solution is not working sir.

 

[mole999]

what part dosen't work? The data was copied from your original post and pasted into a blank work book from A3 down

 

[krishco68]

Sir,
I have given the data, which was entered manually, but when I am applying the given formula, it is showing blank in the cell.