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,

Adisone

Answer 1

Dear master ,

Please suggest me about excel

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,

adisone

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

I know this is late, but use

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

Answer 6

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