Please take a look at this example

A
B
C
1
10
 G =CELL("format",A1)
2
15
 G
3
1/10/2014
 D4
4
5/13/2013
 D4
5
20
 G
6
15
 G
7
8
60
 =SUMIF(B1:B6,"<>D4",A1:A6)