Yes, you have to have one record per geography unit you would like to map, it will not do the roll-up for you 'on the fly'. The sumif sounds like a good method, I tend to also use Group By's in Access for this kind of thing.

Eric

__________________