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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
The first image popped up with an alert, the second just gave me a #value error
Attachments
Upvote
0
