Hi, i need to find a formula that will sum a range of cells based on the name of a city. However the name of the city appears many times but in the same column.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
For example D3:D272 are where the city's are listed. The number of users are in X3:Z272.<o></o>
<o></o>
i.e London may appear several times in column D and each time is corresponding row will have a number. So i need to sum all the numbers in X3:Z272 that line up with London in D3:D272. <o></o>
fficeffice" /><o></o><o
></o>For example D3:D272 are where the city's are listed. The number of users are in X3:Z272.<o
></o><o
></o>i.e London may appear several times in column D and each time is corresponding row will have a number. So i need to sum all the numbers in X3:Z272 that line up with London in D3:D272. <o
></o>
