Currency calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If i have 3 different currencies in one column($, EURO, EGP) ,i want to sum
each currency separate. kindly advise
 
Hi
do you have a column with the currecny code?. e.g. column A the value
and column B the currenca code. If yes try SUMIF:
=SUMIF(B:B,"EURO",A:A)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula for currency or Macro help. 0
Summary of Unique item values 2
Currency list in Excel 1
CONCATENATE & LOOKUP Functions 0
If statement based on currency format 8
Formula for Detecting Currency Format 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Sum Products with VLOOKUP 3

Back
Top