Take a look at the SUMIF() function. For the plus / minus value, you
could return (in a different cell) the amount expected, and subtract
the expected amount from the amount received.