# Sumproduct

#### shimaa01234

##### Active Member
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)

Last edited:

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Why does the row with the AA entry become 1?

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

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?

I wanted to be counted as text format

I wanted to be counted as text format

C2, copied down:

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

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" ?

Last edited:
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...

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

Thank you very much Mr. "Aladin Akyurek"
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))

Replies
12
Views
434
Replies
1
Views
723
Replies
4
Views
801
Replies
9
Views
2K
Replies
3
Views
305

### Forum statistics

1,196,447
Messages
6,015,321
Members
441,889
Latest member
balolaptopgiaolong

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back