I have a worksheet with columns A-P.
A=Hrs
B=Rate
C=Amount Billed (A*B)
D=Hrs Approved
E=Amt Approved (D*B)
F=Hrs Approved
G=Amt Approved (F*B)
H=Sum Approved (E+G)
I=Not Approved (C-H)
J=Approved & Paid (M+N+O)
K=Approved Not Paid (H-J)
L=Variance (C-J)
M=Pmt 1
N=Pmt 2
O=Pmt 3
P=Adjustment

Below is the data for row 2:
166.67
$68.50
$11,416.90
166.67
$11,416.90


$11,416.90
$-
$11,416.90
$(0.01)
$(0.01)
$11,416.90


-0.005
Row 3:
160.00
$25.76
$4,121.60
160.00
$4,121.60


$4,121.60
$-
$4,121.06
$0.54
$0.54
$2,190.78
$1,930.28

-0.54
Row 4:
10.00
$27.80
$278.00
10.00
$278.00


$278.00
$-
$278.54
$(0.54)
$(0.54)


$278.54
0.54
****** END OF DATA******
I need a formula for cell J2 that will calculate cell the sum of M+N+O+P and
will result in 0. Thanks.