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
