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)

Hi Admin

a similar question was asked earlier today - here's the answer i posted to
that question
couple of options -
1) use data / subtotals to automatically generate this (you can then use the
outline levels to hide the details allowing you to print the summary)
(ensure that you've sorted by Currency type first)
2) use a pivot table - data / pivot table and pivot chart report ... to use,
place your cursor in one cell of the data, choose data / pivot table & pivot
chart report, choose NEXT, check the range and choose NEXT, ensure in a new
worksheet and then click the LAYOUT button (before clicking FINISH)- drag
the currencies to the "row" section, drag the values into the "data"
section, now
click OK & Finish and you should have what you want
3) use a formula
=SUMIF($A$1:$A$10,A15,$B$1:$B$10)
where A1:A10 is the range containing the currencies
A15 is EUR name (with the formula being entered into B15)
and B1:B10 is the range to sum
if you have EUR in A15, USD in A16 etc, once you've entered
the formula in B15 for EUR you can fill down for the other currencies

Hope this helps
Cheers
JulieD




"Admin" wrote in message
...
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)

You can use SUMIF function.
Assume that the currecies are in Range A1 to A6 and amounts are in Range
B1 to B6.

Then the formula to sum euros will be
=SUMIF(A1:A6,"=EUR",B1:B6)

to sum Us dollars:
=SUMIF(A1:A6,"=USD",B1:B6)

to sum Pounds:
=SUMIF(A1:A6,"=GBP",B1:B6)

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!