Thank you for letting me know. I got it fixed now; for anyone using their own copy of the sheet, go in to the Data tab, and in DATA!B56 replace the formula with the following:
=(IF(STATUS!BB4=“Adept”,(MAX(STATUS!P28:R33)+STATUS!AK28),IF(STATUS!BB4=“Mage”,(MAX(STATUS!P28:P30)+STATUS!AK28),IF(STATUS!BB4=“Warrior”,STATUS!P28+STATUS!AK28,IF(STATUS!BB4=“Expert”,(STATUS!P28+STATUS!AK28),”-”))))).



