Total of a certain currency

[Tia]

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

 

[Bob Phillips]

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

 

[Tia]

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









- Show quoted text -

Yes the $ and GBP achieved by formatting the cells
the amouts are set in a formating way $ or GBP what i need is to sum
the $$$ amounts alone and the GBP amounts alone in an automatic way
withoust selecting the
Total $=SUM(G16+G18+G20+G21)

 

[Bob Phillips]

That is a shame, the formatting function returns the same value whether
formatted as $ or GBP.

You would need to enter the currency symbol in a separate column to be able
to automatically sum the amounts.

--
__________________________________
HTH

Bob

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









- Show quoted text -

Yes the $ and GBP achieved by formatting the cells
the amouts are set in a formating way $ or GBP what i need is to sum
the $$$ amounts alone and the GBP amounts alone in an automatic way
withoust selecting the
Total $=SUM(G16+G18+G20+G21)

 

[John C]

Are there always GBP and USD on these sheets? Actually, I guess the more
important question is are the USD amounts always on an even numbered row, and
the GBP always on an odd numbered row?

 

[Spiky]

I tried using CELL to do this, but couldn't make it work. There is an
alternative in the morefunc group that will work.
http://www.freedownloadscenter.com/Business/MS_Office_Add-ins/Morefunc.html

Formula would be:
=SUMPRODUCT(--(XLM.GET.CELL(7,B1:B9)="$#,##0.00"),B1:B9)

You would have to find the exact format you are using and enter it in
there.