To calculate/sum all numbers that are formatted in currency?

[Dwexdwex]

In a range of A1 : E20.

There are numbers , text and numbers(that are formatted in currency eg. "$")

How do I filter out the numbers that are formatted in currency format and sum them all up with one line of code?

[FDibbins]

currency is just a format, and excel doesnt "see" formats - they are applied as a visual aid to help the human eye see things better. So excel cannot tell the difference between 20.55 and $20.55 (except maybe though VBA) - unless the $20.55 is actually text and not a value.

perhaps if you know of some way toID that "these" numbers are money, and "those" are just values, we can come up with something for you.

Could you upload a sample workbook (no sensitive date)? Please show what you have, what you want, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.