Hello, I have a Sumif that works for the overall calculation but I am unable to have a lookup to see if it is a branch region or total from cell C5
If it's a branch, it should Check against Export Table L:L
If it's a region, it should check against Export Table M:M
And if it's a total it should sum up everything.
This formula works for everything but I can't seem to get it working for scenarios one and two.
Thank you for your help.