Hey, that works, thanks!

I just realized that I don't want the 'n/a' to negatively impact the
percent. I'm basically tracking goals and so ideally, if everyone meets
their goal, they will achieve 100%. If a 'n/a' is recorded, is there a
way then that I can not have that cell counted in the calculation of
the percent? So, if there are 3 'n/a's, then rather than dividing by
31, excel would divide by 28?

Thanks so much for your help!


--
blazon
------------------------------------------------------------------------
blazon's Profile: http://www.excelforum.com/member.php...o&userid=27409
View this thread: http://www.excelforum.com/showthread...hreadid=469224