I have taken some time and found the solution so here it is for anyone wondering. SUM(CASE WHEN Status = 'Success' THEN `Count` WHEN Status = 'Fail' THEN `Count` WHEN Status = 'None' THEN `Count` … END)