You could use a nested select statement or a second recordset to get the count. Something like:
SELECT *, (SELECT SUM(CPD.Minutes) FROM users AS u2 WHERE u2.UserID = users.UserID AND YearColumn = YearValue) AS MinuteCount FROM users LEFT JOIN CPD on users.id = CPD.User_ID GROUP BY users.display_name ORDER BY users.display_name ASC