Some values in range are really texts.

This may happen when you enter data into cells formatted as text, and change format afterwards. Or when you copy data from elsewhere, and use Paste instead PasteSpecial -Values (this may change cell format to text for various reasons). Simply formatting the range with such values displays them like they were numbers, but really they remain texts. To make the new format applied, you have to edit every such cell.

To check this, you remove alignment from range and enter a suspect cell in edit mode (double-click or select cell and press F2). When the value is numeric, it will be right aligned, when text, then left aligned.

When there is lot of data, it's easier simply correct issue. Format your range as General, or Numeric. Enter 1 into some unused cell (formatted as General), and copy the cell. Select your range, and then PasteSpecial - Multiply. This updates all cells in selected range leaving all values same.

Another issue is, that you use 2 different ranges from sheet 'MCS Data', C:C and Table column MCS_Data[Total Raised]. MS recommends to have all ranges used with SUMIF() or SUMIFS() of same dimension. Ignoring this may affect the result.