Sumifs ,or SUMPRODUCT

try this

=SUMIFS(D:D,A:A,"=2010",A:A,"=2011",A:A,"=2012",B:B,"<>0",B:B,"<>999",C:C,"=71*")

Originally Posted by pradeepjassal

try this

=SUMIFS(D:D,A:A,"=2010",A:A,"=2011",A:A,"=2012",B:B,"<>0",B:B,"<>999",C:C,"=71*")

thanks pradeep, but it did not work. the result comes zero

Try using Filter

for the sheet provided answer is -1110069.85

Still working on Sumif will update once done