Advanced use of the ADDRESS function

[Sean Anderson]

Hello,

Can anyone help me with this problem?

Let's say I have the following table.

.......Jan Feb Mar Apr
Red [5 ] [10] [15 ] [8]
Green [1 ] [ 2 ] [1 ] [3]
Blue [20] [50] [20] [ 99]

(99 is in cell $E$4)

And let's say I have the following data input boxes

$A$5 Color _____ (E.g., Green)
$A$6 Month _____ (E.g., Mar)

Answer _______ (My formula goes here)

I need a formula that will do the following once I typed in, e.g, "Green" in cell $A$5 and "Mar" in cell $A$6. It needs to add 1 + 2 + 1 = 4. Using the data that I entered into the variable input boxes, it needs to add all the numbers in the single row starting from Green/Jan all the way through Green/Mar.

And it should work with any color/month combination that the user chooses.

I could insert a row between each of the colors and add rolling accumulator functions, but that will interfere with something else I have planned.

I learned from this site how to find the address of any cell inside a table. For example, the address of cell Green/Mar would be $D$3 by using the following formula: =ADDRESS(MATCH($A$5,A2:A4,0),MATCH($A$6,B1:B4,0)). Now I'm trying to take this a step further and sum a range of cells in a table using variable input filters for the color and month.

Any suggestion Y'all?