Thread: sum by currency
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Admin[_2_] Admin[_2_] is offline
external usenet poster
  
Posts: 2
Default sum by currency
I have two column as you see below:
EUR 5,000.00
USD 12,500.00
EUR 1,251.00
EUR 12,544.00
USD 5,555.00
GBP 15,455.00

How can I sum the amount Per currencies
Tot GBP (function)
Tot EUR (function)
Tot USD (function)


Reply With QuoteReply With Quote