OK so I found a way to find where the valuse should exist but I am still
unable to view them?

I trimmed down my data set to one version so sumif is unnecesary then
used

sum(A$1:A1) and copied it down then where ever the value changed I
figured there most be a decimal in that value I have the view so that
I can more decimals than I should need to in both columns but I still
can't view the actual decimal it just displays .0000000000

also the decimal change is in the 12th decimal #

thanks for your help


--
clane
------------------------------------------------------------------------
clane's Profile: http://www.excelforum.com/member.php...o&userid=11865
View this thread: http://www.excelforum.com/showthread...hreadid=381265