No idea where to start!

[Taryn]

So in the attached file I need a formula in the summary tab in row 115.
For November the number should be -122,180.75
I need it to look up the month and the LOB in D99 and bring back the calculation in cell T289, (This calculation in cell T289 is just there so you can see what I need to add up from column N so I cannot reference T289 in the formula.)
The Key in column Q can be used as these letters are unique to the line it is on.

Help please!

 

[Peter Bartholomew]

This still requires some manual input to select direct and negated cells by key

 

[Taryn]

How do I get the values to change between the months? And to lookup the LOB name?
Your formula just gives me Novembers value and doesn't factor in the LOB name?

TIA

 

[Peter Bartholomew]

How do I get the values to change between the months?
That would normally be achieved with a further XLOOKUP.
In this case, since your timeline comprises months 1-12, a simpler lookup by index is possible, With 365, I have used
= CHOOSECOLS(inputData, MONTH(date))
[All I sought to do was demonstrate looking data up by key rather than manual 'point and click'].

And to lookup the LOB name?
I have no idea what this is or where it should be looked up.

Note: I use 365 and I suspect my methods are very different from those you require.
There are others on this forum that could help you with direct cell referencing and non-array formulas.

 

[Taryn]

Thank you for your help I can see it works with your data but I can't get it to work in my actual file and really struggling to work out what it's doing with all the named ranges, I think i'll be more comfortable with direct cell referencing if anyone else has any ideas, I just use Sumifs for the other lines but these other lines are only needing to add one or two lines together from the key so it's a lot easier

 

[Debaser]

Do you have a table somewhere that indicates which key values should be added and which subtracted? The simplest method I think would be to have an additional column that indicates in some way how each key value should be treated, then you can simply build that into your SUMIFS calculations.

 

[Taryn]

In the end I just added and subtracted a load of sumifs, formula looks clunky but at least it works

Thanks anyway