yeah, that was completely out of left field as compared with =SUM(CODE(MID(LOWER(SUBSTITUTE(SUBSTITUTE(C3,”:”,””) which, while convoluted and a terrible formula/method to use when sharing spreadsheets with others, is far more nuanced