I've been screwing around with SUMIF for a little while

Let us know if you're still not seeing the expected results, and please
post some sample data. I'm sure we can get you squared away.