Big Sumif
No formula would be able to detect the fact that you have emboldened a
cell, so you would have to develop a macro to do it that way.
Alternatively, you could devise some other way of indicating which
cities you want to be included - for example, in cells A1 to A10 you
could have several pull-downs using the list of cities as another way
of indicating your choices.
Hope this helps.
Pete
|