How about this

Where E1 is State your looking at. Also format cell with Formula to %

=SUMPRODUCT((--($C$2:$C$30=E1)*(D2:D30)/SUM(D2:D30)))

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562214