Hi sqlishard. Welcome to the forum.

Try this in I2.
Formula: copy to clipboard 
=SUMIFS(G:G,A:A,A:A,C:C,C:C,D:D,D:D,H:H,"N")




A
B
C
D
E
F
G
H
I
1
ID
Doc
Space
Code
Amount
Date
OC
Stat
2
4000
1670
D001
EFX
$5,000.00
11/1/2016
0:00
C
0
3
4000
2805
D001
EFX
$5,000.00
11/1/2016
0:00
N