try this
=SUMIFS(D:D,A:A,"=2010",A:A,"=2011",A:A,"=2012",B:B,"<>0",B:B,"<>999",C:C,"=71*")
try this
=SUMIFS(D:D,A:A,"=2010",A:A,"=2011",A:A,"=2012",B:B,"<>0",B:B,"<>999",C:C,"=71*")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks