array formula possible in this case?

[Bishonen]

hi all,

is there a possibility to use this code:

Please Login or Register  to view this content.

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

[:) Sixthsense :)]

Please Login or Register  to view this content.

to sum the values from A1 to Z1? I'd like to avoid using the same formula 20++ times

Array Formula - Should be entered with Ctrl+Shift+Enter

Please Login or Register  to view this content.