I have a table of data which I need to parse based on 2 specified criteria and populate a graph table. The problem is that one field that is parsed is in a column and the other in a row, at the intersection is the data I want to sum. I have tried sumproduct, various array formula etc but cannot get it right.
You will see in the attached the first criteria is CstCtr and the other is the month end date, the graph sheet has CstCtr '3810' in field A49 and the month end dates are in row 45, the DataBaseFcst sheet has the data. I hope I have made my question clear, but I think if you check the attached it should be clear.