A small tweak to Glenn's formula does the trick: <ul>[*]{=SUM(VALUE("0"&SUBSTITUTE(LEFT(RngToSum,SEARCH(CHAR(10),RngToSum&CHAR(10))-1),"$","")))}[/list]UniMord said:Unfortunately, it doesn't work in my particular case since all the cells with entries start with a $ sign, and adding the "0" won't work.
Is there any way to sneak a Carriage Return into a Custom Format?
For example, I'd like the format to show: $#,##0(CR HERE)"(I & B)"