Forum Discussion
summing cells with $ sign
Ideally the cells should contain numbers such as 37 or 123.45, and their number format should be set to a currency format with $. That way, you can simply sum the values.
But if the cells contain text values that start with $, you can use a formula like this:
=SUBSTITUTE(G3,"$","")+SUBSTITUTE(O3,"$","")
Format the cell with the formula as currency. Or if you prefer the result as a text value again:
=TEXT(SUBSTITUTE(G3,"$","")+SUBSTITUTE(O3,"$",""),"$ #,##0.00")
Ideally the cells should contain numbers such as 37 or 123.45, and their number format should be set to a currency format with $. That way, you can simply sum the values.
But if the cells contain text values that start with $, you can use a formula like this:
=SUBSTITUTE(G3,"$","")+SUBSTITUTE(O3,"$","")
Format the cell with the formula as currency. Or if you prefer the result as a text value again:
=TEXT(SUBSTITUTE(G3,"$","")+SUBSTITUTE(O3,"$",""),"$ #,##0.00")
HansVogelaar Wow what a quick reply.. the substitute formula did work out fine. Thank you very much.
