Need Help : SUM Different Currencies

Are the $ entries numbers formatted to display the $ or are they text entries?

What result do you get using an =SUM(range) formula?

I don't know if that can be done with built-in functions.

You may need a VBA function to do it. I can't help with that.

Try this...

Data Range

	A	B	C	D
1	Amount	Format	$$$	No $
2	$89	C0	1003327	856501281
3	6500000	G
4	1259	G
5	$6	C0
6	$1,000,000	C0
7	850000000	G
8	12	G
9	10	G
10	$3,232	C0

Enter this formula in B2 and copy down as needed:

=CELL("format",A2)

Enter this formula in C2:

=SUMIF(B2:B10,"C0",A2:A10)

Enter this formula in D2:

=SUMIF(B2:B10,"<>C0",A2:A10)