Sum of different currencies partly

[colderthanice]

I have a problem of totaling different currencies.

5$
4$
5E
6$
5E
--------
15$
10E

I select E and summing, select $ and summing. This is very hard if this list is long and changing always.I tried to make a new column and entered in currency and used some other functions of sum. Solved but this was not easy either.

Please say me the way of summing different currencies partly

[flix]

1. you could run a custom filter to filter all but one currency and then sum them up!
2. have you tried using SUM(IF(...........)) function to only sum one of the currencies?

my 2p

[Aladin Akyurek]

******** ******************** ************************************************************************>

Microsoft Excel - Book51 ___Running: xl2000 : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
D2D3 =
	A	B	C	D
1	*	*	*	*
2	5$	*	$	15
3	4$	*	E	10
4	5E	*	*	*
5	6$	*	*	*
6	5E	*	*	*
7	*	*	*	*
Sheet1 *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

The formula in D2 is...

=SUMPRODUCT((RIGHT("00"&$A$2:$A$6)=C2)+0,LEFT("00"&$A$2:$A$6,LEN("00"&$A$2:$A$6)-1)+0)

[Juan Pablo González]

Just a suggetsion, try using an extra column for the 'E' or the '$'... that way, you can easily use SUMIF to add the cells of one specific condition, AND, the numbers WILL be real numbers...

[colderthanice]

Dear friends,

Do u think these are the easiest way? I tried making new column but this is not easy too. Waiting for ur new replies.

Thanks

[Juan Pablo González]

What problems are you running to ? what difficulties ?

[colderthanice]

1.I have to sum the numbers at bottom
2.I can't add new columns

I think Excel has another ways of sum different currencies

[Aladin Akyurek]

1.I have to sum the numbers at bottom
2.I can't add new columns

I think Excel has another ways of sum different currencies

Is it...

******** ******************** ************************************************************************>

Microsoft Excel - Book51 ___Running: xl2000 : OS = Windows Windows 2000
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A7B7A8B8 =
	A	B	C	D
1	*	*	*	*
2	5$	8E	*	*
3	4$	2$	*	*
4	5E	6F	*	*
5	6$	7$	*	*
6	5E	8$	*	*
7	15	17	*	*
8	10	8	*	*
Sheet1 *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

A7, copied across...

=SUMPRODUCT((RIGHT("00"&A$2:A$6)="$")+0,LEFT("00"&A$2:A$6,LEN("00"&A$2:A$6)-1)+0)

A8, copied across...

=SUMPRODUCT((RIGHT("00"&A$2:A$6)="E")+0,LEFT("00"&A$2:A$6,LEN("00"&A$2:A$6)-1)+0)

Would you like to have these formulas in the Turkish language instead?

[colderthanice]

I would be glad if u send me writing of Turkish version

[Aladin Akyurek]

I would be glad if u send me writing of Turkish version

I'm sorry I kept you waiting. The formula from the last exhibit in Turkish...

=TOPLA.ÇARPIM((SAĞDAN("00"&A$2:A$6)="$")+0;SOLDAN("00"&A$2:A$6;UZUNLUK("00"&A$2:A$6)-1)+0)

Also sent you the workbook.