Sumproduct

[shimaa01234]

Is this formula can be applied to characters
=SUMPRODUCT(--($A$1:$A$1000>=A2)*($A$1:$A$1000<A3),$B$1:$B$1000)<a3),$b$1:$b$1000)
<a3),$b$1:$b$1000)
<a3),$b$1:$b$1000)<a3),$b$1:$b$1000)<a3),$b$1:$b$1000)
<a3),$b$1:$b$1000)
<a3),$b$1:$b$1000)<a3),$b$1:$b$1000)

ID	Sum of money
1	1000
2	2000
3	3000
4	4000
5	5000
6	AA
RESULT
ID	Sum of money
1	1000
2	2000
3	3000
4	4000
5	5000
6	1

<tbody>
</tbody>

</a3),$b$1:$b$1000)<a3),$b$1:$b$1000)
</a3),$b$1:$b$1000)
</a3),$b$1:$b$1000)<a3),$b$1:$b$1000)<a3),$b$1:$b$1000)
</a3),$b$1:$b$1000)
</a3),$b$1:$b$1000)

 

[Aladin Akyurek]

Why does the row with the AA entry become 1?

 

[shimaa01234]

So, how is calculate the text within this formula?
Can it be counted depending on the number of characters once?
And again as a word

 

[Aladin Akyurek]

So, how is calculate the text within this formula?
Can it be counted depending on the number of characters once?
And again as a word

I did not get what you mean. But what is the answer to the question I posed, that is, why 1 when AA?

 

[shimaa01234]

ADVERTISEMENT

I wanted to be counted as text format

 

[Aladin Akyurek]

I wanted to be counted as text format

C2, copied down:

=IF(ISNUMBER(B2),B2,IF(ISTEXT(B2),1,""))

 

[shimaa01234]

ADVERTISEMENT

I'm sure you are able to do this
You're a genius Mister "Aladin Akyurek"
Thank you very much, you're a really nice guy
Can we bring the number of characters?
Is it possible to apply this formula, the same conditions as the formula "sumproduct" ?

 

[Aladin Akyurek]

I'm sure you are able to do this
You're a genius Mister "Aladin Akyurek"
Thank you very much, you're a really nice guy
Can we bring the number of characters?
Is it possible to apply this formula, the same conditions as the formula "sumproduct" ?

It's a mystery to me why the length a text value must be determined in a column of 'Sum of money'...

C2, copied down:

=IF(ISNUMBER(B2),B2,IF(ISTEXT(B2),LEN(B2),""))

Another mystery is why insist on a SumProduct formula while there is nothing summarize effecting a conditional summing...

 

[shimaa01234]

Thank you very much Mr. "Aladin Akyurek"
All your solutions wonderful
But I wrote this formula
( IF(ISTEXT(B2);LEN(B2);B2)=
What is the difference between This and your formula

 

[Aladin Akyurek]

Thank you very much Mr. "Aladin Akyurek"
All your solutions wonderful
But I wrote this formula
( IF(ISTEXT(B2);LEN(B2);B2)=
What is the difference between This and your formula

Try also:

=IF(ISNUMBER(B2),B2,LEN(B2))