Re: SUM UP DIFFERENT CURRENCIES

Obviously they are numbers fomatted with different currency symbols.

[ and sorry for the incovenience]

"David Biddulph" wrote:

So how are your amounts entered? Are they all text strings, or are they
numbers formatted as currency with different symbols, or ...?

[And in future, please supply the relevant information when you ask the
question. It'll save your time, and ours.]
--
David Biddulph

"Irfan" <Irfan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA278BFD-B62D-482C-BA4A-A3523ECC1EA9@xxxxxxxxxxxxxxxx
Thanx. But i feel u do not understand my question. Here is list

Date Supplier Product Qty Amount
27/01/2008 XYZ ABC 20 £23.00
27/01/2008 OPL Buns 10 £22.00
29/01/2008 OBS Deca 3 $3.00
29/01/2008 OPL Deca 5 $3.00
29/01/2008 OBS Fil 3 $3.00
27/01/2008 XYZ ABC 20 $3.00

What i want to sum up the dollars and pounds separately.

"ryguy7272" wrote:

Use a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivottables.htm

Regards,
Ryan--

--
RyGuy


"Irfan" wrote:

I have a list in which a column contains amount paid to various
suppliers in
various currencies such as Pounds, Dollars and Yen. I want to sum up
the
amount in different currencies Like:

Total Dollars Paid
Total Pounds Paid
Total Yen Paid

Please help



.

Relevant Pages

  • Re: fortran character set
    ... There are no currency symbols in Fortran as such. ... The problem is all the non-dollar currency symbols. ... If one is is referring to currency, a real pound sign is a ... The f2003 character set includes the hash mark but not the real pound ...
    (comp.lang.fortran)
  • Conditional Formating
    ... I have a number of textboxs, ... numbers and currency symbols. ...
    (microsoft.public.excel.programming)
  • CompareValidator not working
    ... The CompareValidator doesn't seem to work correctly. ... I saw in the MSDN that Currency ... is supposed to allow decimals with Currency symbols ("A decimal data type ... I still get the Validator message. ...
    (microsoft.public.dotnet.framework.aspnet)
  • allow all currency symbols
    ... Is there a way I can validate the input on a textbox for currency ... including all currency symbols.. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: =?ISO-8859-1?Q?Sch=FCssel:_Imbecile?=
    ... >Someone manufactures widgets. ... >all over the place, so he's getting paid in Euros, dollars and yen. ... >against adverse commodity and currency movements. ... explanation of why people use them is a mystery. ...
    (uk.politics.misc)