hi all,

is there a possibility to use this code:

=RIGHT(A1,5)-LEFT(A1,5)
to sum the values from A1 to Z1? I'd like to avoid using the same formula 20++ times and then summing it. I thought of an array formula but I can't think how to implement it.

Thanks