Hi,
I'm trying to get the sum of the leftmost character in each cell in part of a row. In the attached example, I'd like to get the result 17.
I tried this formula but it didn't work: =sum(--left(B1:H1,1))
Thank you!
Hi,
I'm trying to get the sum of the leftmost character in each cell in part of a row. In the attached example, I'd like to get the result 17.
I tried this formula but it didn't work: =sum(--left(B1:H1,1))
Thank you!
Did you confirm that formula with Ctrl Shift Enter, rather than just Enter?
Just realized that it works if I make it an array formula. But the problem is that I want it to function as an array formula going down the whole column. Every time a new row is entered, I want the formula to calculate for that row. It's like I need it to do be an array in both directions.
This worked for a single row: =arrayformula(SUM(--LEFT(E2:J2,1)))
But then I tried this to get it to repeat down the column and it didn't work: =arrayformula(SUM(--LEFT(E:J,1)))
Thank you!!
Are you doing this in Excel, or some other app?
ARRAYFORMULA is not an Excel function - are you using Google Sheets?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yeah, I'm in Google Sheets. I shouldn't have assumed it would work the same way. Sorry about that.
Yes, you should have mentioned it, and I have now moved this thread to the section where you should have asked it.
Thanks. How do I get to that thread?
Thanks, Fluff13. Sorry to waste your time.
Oh, I see. It's here. Sorry.
I am not sure if you only want to get the sum of the leftmost character of cells in columns B:H of the current row, or if you want a running total.
If only in a single row then please try: =SUMPRODUCT(--LEFT(B1:H1,1))
If a running total then please try: =SUMPRODUCT(--LEFT(B$1:H1,1))
If neither of these does what you want then please utilize the instructions in the banner at the top of the page to upload a sample .xlsx file.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks