I'm having trouble with getting some percentages to reference from one worksheet to the next. The percentages in the original sheet will not appear correctly in the next sheet as references. The only thing that shows up is #VALUE. The percentages are calculated from the partial sums of different number sets that constitue the overall total. What might I be doing wrong?