I can't quite work this out.

I want to sum a group of numbers dependant on the criteria in the row.

it looks like this:

Rural Town 0 0 0 0 0 8865
CBD 3596 4205 3853 3841 4028
Rural Town 5463 5503 6065 5953 5915 6056
Suburban 0 6739 6999 7604
CBD 0 0 0 5220 5138
Rural Town 4918 4721 5218 5810 5284 5180
Rural Town 0 0 0 7265 7403 7790

I only want to sum the CBD, or rural etc

Any ideas anyone on how the sumif would work?

Thanks in advance.

PS, I can't sort them so need to do it in a formula.


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