+ Reply to Thread
Results 1 to 2 of 2

adding a column of euros

  1. 02-24-2021, 07:46 AM #1
    btman
    btman is offline
    Registered User
    Join Date
    05-01-2010
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    7

    adding a column of euros

    I am having trouble adding a column of euros because there are commas involved. Any help appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-24-2021, 08:02 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: adding a column of euros

    Try below

    =SUMPRODUCT(--(SUBSTITUTE(B1:B21,",",".")))
    or try

    =IFERROR(SUMPRODUCT(B1:B21+0),SUMPRODUCT(--(SUBSTITUTE(B1:B21,",","."))))
    Last edited by samba_ravi; 02-24-2021 at 08:06 AM.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    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. Format cells as $ or Euros if one cell is US or EU
    By ELC774 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2013, 01:26 AM
  2. How to convert euros in pounds
    By Sheepkin_Coat in forum Excel General
    Replies: 3
    Last Post: 11-25-2008, 04:13 PM
  3. [SOLVED] How can I get Euros in the taskbar of Excel 2000
    By WimE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2006, 01:25 AM
  4. [SOLVED] How do I not display the Euros sign, if value is 0?
    By Connie in forum Excel General
    Replies: 2
    Last Post: 05-04-2006, 11:00 PM
  5. Excel - Euros to U.S. Dollars
    By Tricia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2006, 01:10 PM
  6. Gagnez 1.000.000 euros par an comme moi
    By Virginie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-05-2005, 11:05 AM
  7. [SOLVED] Comment j'ai gagné 1Million d'Euros
    By Melanie in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-13-2005, 03:05 PM
  8. How do i input euros and have it convert into dollars in the same.
    By n1ghthawk in forum Excel General
    Replies: 1
    Last Post: 01-21-2005, 01:06 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