I have a dashboard that is fed from a data connection to another workbook. The feeder workbook has certain columns with monetary values in them and a dollar sign ($) transfers to the dashboard tables upon data refresh. However, because of the dollar sign being pulled in, the SUMIF function will not work (because it doesn't know what to do with a dollar sign - it is an actual dollar sign, not simply a cell format). I have no control over the format of the feeder workbook, so I cannot remove the dollar sign in front of the number. I'm looking to see if there is a way to create a formula that will accomplish the SUMIF that I need, but perhaps also incorporate a TRIM or LEN formula to get it to ignore the dollar sign. Any thoughts?