# How sum by the condition lenght of character in excel?

• ### Question

• Dear master ,

Please suggest me about sum by condition grouping the length of character in excel

this my try, =SUMIF(A4:A7, "=2",B4:B7)

 Number1 amount Number2 amount 22 20000 22 20000 333 10000 333 10000 33 10000 33 10000 222 10000 222 10000 2digit ? 3digit ?

Best regard,

Thursday, June 29, 2017 6:18 AM

### All replies

• Dear master ,

I want to know how to sum by group length of character

 Number1 amount Number2 amount 22 20000 22 20000 333 10000 333 10000 33 10000 33 10000 222 10000 222 10000 2digit ? 3digit ?

Best regard,

• Merged by Tuesday, July 4, 2017 8:54 AM duplicated
Thursday, June 29, 2017 5:20 AM
• Hi,

You can get the length of characters in a cell by using "Len" function.
If a target cell is B4, you can write "=Len(B4)" in cell A4.

Please watch and guess from the below:

Ashidacchi

• Edited by Thursday, June 29, 2017 7:52 AM
Thursday, June 29, 2017 7:43 AM
• Hello,
This forum(Excel for Developers) is for development issues related to Excel Object Model and your problem is more related to Excel product feature, so I would move this thread into Excel IT Pro Discussions.
Thanks for your understanding.
Best Regards,
Terry
Friday, June 30, 2017 5:45 AM
• I would simply add a Helper column and insert a LEN formula and then use that column for the Criteria. You could hide the helper column.

See the screen snippet below.

Regards, OssieMac

Tuesday, July 11, 2017 6:49 AM
• I know this is late, but use

=SUMPRODUCT((LEN(A4:A7)=2)*B4:B7)

Thursday, July 13, 2017 9:12 PM
• Hi Sdisone,

How is your issue?  Have it been resolved? (It is about one month since you posted.)
If not, please share your file via cloud storage such as OneDrive, Dropbox, etc?

Ashidacchi

Friday, July 28, 2017 10:50 AM