I have the following formula:

=MAX(SUMIF($A:$A,LEFT($A283,5)&"*@*",C:C),SUMIF($A :$A,$A283,C:C))

The trouble is, some numbers in C are negative. I want to add
them up too, or rather their absolute values.

--
dman