Thats really cool! Can this formula take into consideration additional status columns? The other columns are duplicates and contain the same labels. For example I tried this:
SUM(SWITCH({Status1},"FL1",50,"FL2",50,"FL3",200,"FL4",150,"FL5",350,"FL6",75,9999),(SWITCH({Status2},"FL1",50,"FL2",50,"FL3",200,"FL4",150,"FL5",350,"FL6",75,9999)
Which sadly didnt work