I have a sheet...see attached............. that I need help with. I color coded it to try and make it easier to understand what I want to do. So what I want to do is input a dollar amount in the yellow cells. A letter will be entered into the Blue cells. This letter will be one of the letters from the purple cells at the bottom. I need a formula that looks at the letter in the blue cell and then takes the dollar amount from the yellow cell next to it and adds it to a running total in the green cell. So if the letter in the blue cell is a Z it would get totaled in the green cell below the Z. If the letter in the blue cell is an A it would get totaled to the amount in the green cell below the letter A. I hope this all makes sense.
Bookmarks