+ Reply to Thread
Results 1 to 2 of 2

add different currencies

  1. 09-07-2015, 01:37 PM #1
    engmhelmy
    engmhelmy is offline
    Registered User
    Join Date
    06-21-2014
    Location
    Egypt
    MS-Off Ver
    MS 2010
    Posts
    72

    add different currencies

    Dears

    I have a total of project some in EGP and some in USD , i want to add each separately , what is USD added to USD total and what in EGP added to EGP only

    attached is a sample if any one could assist Book3.xlsx
    Reply With QuoteRegister To Reply
  2. 09-07-2015, 01:43 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: add different currencies

    Try this...

    Data Range
    A
    B
    C
    D
    E
    1
    PO Amount
    Currency
    EGP
    885000
    2
    65,265
    USD
    USD
    1854908
    3
    88,424
    USD
    ------
    ------
    ------
    4
    391,332
    USD
    5
    139,574
    USD
    6
    258,635
    USD
    7
    232,849
    USD
    8
    112,267
    USD
    9
    415,524
    USD
    10
    25,723
    USD
    11
    590,000
    EGP
    12
    295,000
    EGP
    13
    3,560
    USD
    14
    121,756
    USD


    This formula entered in E1 and copied down:

    =SUMIF(B$2:B$14,D1,A$2:A$14)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need Help : SUM Different Currencies
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-28-2015, 11:33 AM
  2. [SOLVED] Using different currencies in the same workbook
    By Stubo23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2014, 10:58 AM
  3. currencies always have an extra .0
    By Ir1e in forum Excel General
    Replies: 6
    Last Post: 11-28-2013, 07:41 AM
  4. Multiple Currencies
    By Nikamorphosis in forum Excel General
    Replies: 5
    Last Post: 08-13-2013, 04:51 PM
  5. Currencies
    By spiderlegs in forum Excel General
    Replies: 4
    Last Post: 07-10-2009, 12:53 AM
  6. [SOLVED] different currencies
    By BAZZA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2005, 09:06 AM
  7. converting different currencies to one
    By alexander in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-11-2005, 04:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1