How do I Sum a range that has Left Len function formulas in the range?

Hi All,

I know this must be simple, my brain must not be working at all today.

I have 3 columns that have single digit numbers in each column that contains left, mid, right Len formulas in each column.

Im wanting to use a formula or even the status bar at bottom to Sum each column separate.

Thanks,
Brian

You should be able to use the SUM() function, with one small change. LEFT() and other text functions return text strings and not numbers (and the SUM() function will ignore text -- even numbers stored as text). The key change will be to include something so that Excel will see the results of those text functions as numbers. I tend to use the VALUE() function https://support.office.com/en-us/art...c-bc2d3953d8c2 =VALUE(LEFT(...)). Other strategies are to multiply by 1, add 0, other numeric operation =1*LEFT(...).

Try:

Formula:

Please Login or Register  to view this content.

dragged across.

Thanks to all of you for replies, I’ve not got a chance to try all 3 of the suggestions because I’m at work.
I know of at least one that did work. I will add reputations and show solved in a little while, I need to get back to work at the moment
Thanks,
Brian

You're welcome. Thanks for the rep.