Total
CBD 57 8 2 67
A 56 2 3 61
Rural 5 56 4 65
CBD 65 84 65 214
=SUMIF(A2:A5,"=CBD",E2:E5)
=SUMIF(A2:A5,"=Rural",E2:E5)
=E6+E7


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=546329