SUMIF+LEN based on criteria

[toci]

Hello folks,
I am trying to figure out this formula but still haven't found solution
I will try to explain my problem here if you don't want to download excel file.

So, I need to SUM only cells where I have "x" or "xx". In this case my SUM should give me =3 as total.

Thanks in advance!

[Special-K]

There is no file to download.

If you want o post a file use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

Your problem doesnt make sense with what you've posted.
Your subject title says SUMIF+LEN yet your description of the problem does not refer to LEN.
In your description you say you want to SUM and the total should be 3 but there's nothing to suggest that it should be 3.
At present it looks like you just want to COUNT not SUM.

Check your posting again.

Assuming there is some numeric data missing from your post does this work?

=SUMIF(B3:E3,B2:E2,"x")+SUMIF(B3:E3,B2:E2,"xx")

[AlKey]

Try this
Enter in F1

=LEN(B1&C1&D1&E1)-LEN(SUBSTITUTE(B1&C1&D1&E1,"x",""))

v	B	C	D	E	F
1	x	xx	p	zz	3