If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
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) |
#6
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|