Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there a way to use the currency format in a conditional sum?
I want to add more values arranged in a column, but the numbers are formatted
differently - some of them are formatted with the dollar currency and others with the Euro currency. Is there a way to use the sumif on this column? How can I make a real difference between the two types of formatting, since I see Excel treats all as numbers. Thank you |
#2
|
|||
|
|||
Short of writing code there is no way I'm aware of to use the format
properties of other cells to arrive at a sum of those cells. However, if you have a list of Euro figures and Dollar figures, they must be labeled somehow, probably in a different column, to allow someone viewing the list to make sense of it all. Is there any commonality between the Euro labels and the Dollar labels? If yes, then you can use any of a number of functions to arrive at your totals. What additional info do you have to work with? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency format | Excel Worksheet Functions | |||
Can I insert excel spreadsheet in word and keep currency format? | Excel Discussion (Misc queries) | |||
Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
convert a numerical currency into word format | Excel Worksheet Functions |