I did a precursory search, but couldn't seem to find anything that would help. I'm trying to write a =sumif formula into the green colored cells, based on numbers entered into the orange colored cells, determining from a list of colors in the drop down menu at the right of each of the orange colored cells. I've tried naming the range with the cells selected, and I still get error messages. Is there something I'm just not seeing, or is this complicated by the fact that there are blank cells throughout the sheet?