Thread: Big Sumif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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