SUMIF

[RickBuckley]

When I use SUMIF it creates several cells below the result cell filled with "0". Every thing was working great and then this started happening. i select. 

[#2]

@RickBuckley 

If A104:A110 is the criteria range and B4:B110 the sum range, you should use

=SUMIF(A4:A110,D122,B104:B110)