Hi, I have data as attached. I have the sumif function which works fine; but when I filter the data by selecting a city, the sumif value does not change accordingly. Please help. See attached data. jay