I see that I have not gotten back to you and completely forgot about this post. I finally realized the problem today when I tried to rework this.

It was the formatting of my numbers i was summing. I REPEAT it was the formatting of my numbers. The numbers were in text and when I reformatted them to the numbers to "accounting" the sums showed up.

Sorry if I broke the rules by responding sooo late but nothing was wrong with the formula but with the data I was searching. Thanks for helping!!