How do I get a total sum based based on text in the columns?

Hi WheelchairWilly 

 

 

Your problem is that you want to count the number of non-null values in that column at the end of each column, right?

 

First of all, you can replace the letters of each column with 1 in Power Query

 

Then change their type to whole number

 

Then click close&apply
This is the result you want

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.