No, i actually made that change before but it doesnt make a difference. It's weird, the way the formula is, it should be taking a group of numbers that add up to 33,603.46 and then dividing cell I36 which is 2570.66 by the 33,603.46 to return a value of 0.0765. However, it returns a value of 5.53 which, if i work backwards, means that instead of totaling the numbers at 33,603.46, it's adding them up to be 464.00!! And the smallest number in that group is 1,342! It's especially wierd since it works correctly in all the other cells in that column. here's the formula exactly as it's entered:

=SUMPRODUCT(--($C$12:$C$25=$C36),I$36/(I$12:I$25+1E-99))

Any ideas?