I don't see anything wrong with your formula. My guess would be that some of
your numbers are text rather than numbers. Check the formatting of your data.

Also, you could try this:

=SUM(VALUE(E29:AA29))

Enter this as an array formula. Ctrl-Shift-Enter instead of just Enter. If
done correctly, you should see { } surrounding the formula in the Formula Bar.

HTH,
Elkar


"Dragon" wrote:

I'm trying to add multiple columns in a single row. I put the formula in the
box at AB29 and used =SUM(E29:AA29) but the total figure in AB29 is way off!
What should I do?
--
Dragon163