In order to use the SUMIF function, we will first need to find out a list of unique cities using the inbuilt advance filter. Once done, follow the following formula - {=SUMIF ...