making the rows dynamically adjust really ramps up the confusion. cell M6 has an offset formula in it that will adjust the range automatically as you add values to A and B
note that if you add to A and not B you will get an error. all ranges must be the same length


i also added a data validation list. when you have cell K6 selected go to data->validation to see exactly what that is. not too confusing

then i used a lookup in L (which is hidden) that returns a numerical month so that the formula in M6 works

again this really ramps up the confusion, i hope it's not too overwhelming

Attached Files

book1.zip (5.9 KB, 83 views)

__________________
--Mark

Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?