You don't need SUMIF( ) - try this:

=IF(OR(A1=50,A4<100),sum(C1:C4),IF(AND(A2=50,A4=1 00),sum(C1:C4),0))

I don't know what you mean by "..and so on!"

Hope this helps.

Pete