Question on SUMIF came up a couple of times in the forum. @ipazin created an example for this and shared it in this thread: Sumifs Excel - #14 by ipazin
@elsamuel also provided an example for this: Sumif and Conditional formatting ideas - #2 by elsamuel