Is the $ and GBP achieved by formatting the cells, or is it a text string
for the amount that includes the currency indicator?

--
__________________________________
HTH

Bob

"Tia" wrote in message
...
Hi

Im working on an invoicing workbook sometime i have to issue invoices
in GBP not only in USD
they are in currency format and i am trying to find a way to have a
formula that allows me to know the total amout of all the invoices in
GBP and all the invoices issued in USD

G
15 Invoicing amount
16 50,000.00 $
17 3,000.00 GBP

23 Total GBP ???
24 Total USD ???
25 Thank you in advance