If you are going horizontally instead of vertically and they are all numeric, you could try something like this

SELECT ISNULL(col1-col1, 1) + ISNULL(col2-col2,1)+...

If they are not numeric, you could do...