| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif on Currency format
Hi,
I'm travelling for business throughout Europe. I've setup my expense claim in Excel in both Euro and GBP format on claims here and there. Would anybody know of a trick to do a SUMIF based on the currency format used, in order to get the total amounts in GBP and the total amount in Euro (each in it's own cell)? Thanks in advance for your help! Marc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Currency format | Excel Discussion (Misc queries) | |||
| Sumif only numbers formated as currency | Excel Worksheet Functions | |||
| format cells for currency 2450 and have it format to $24.50? | Excel Worksheet Functions | |||
| Change General Format to Currency Format | Excel Worksheet Functions | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Threaded Mode
