username using * in the criteria countif excel : [Hello please help me, i m searching sum of class of each student using countif formula, but any student have unique username like A*di (in the image) and so the calculation is false. And any other student using username like </John>, and 'Angel. and make calculation false][1]


  [1]: https://i.stack.imgur.com/LrYJ5.jpg