Instead of your formula, try using,
Formula: copy to clipboard
=SUMIFS('csm report'!H:H,'csm report'!C:C,C5)