I have attached a small portion of the spreadsheet that I am trying to manipulate. I would like the formula cell to add any cells from column A that match the city specified. I have been on many forums and tried many different formulas to get the one in the excel sheet. My brain is fried and I don't know why it's not adding the cells. I need someone else to look at this. Thank you!