Total of a certain currency
 

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

Total of a certain currency
 

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

Total of a certain currency
 

On Aug 4, 1:18*pm, "Bob Phillips" wrote:
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- Hide quoted text -

- 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)

Total of a certain currency
 

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

"Tia" wrote in message
...
On Aug 4, 1:18 pm, "Bob Phillips" wrote:
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- Hide quoted text -

- 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)

Total of a certain currency
 

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?
--
John C


"Tia" wrote:

On Aug 4, 1:18 pm, "Bob Phillips" wrote:
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- Hide quoted text -

- 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)

Total of a certain currency
 

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/B.../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.